cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Update Multiple Rows in SQL with a condition using Power Automate

Hello Experts,

This is about SQL Update Row using power automate.

 

I have a challenge/scenario in updating multiple rows in SQL Table with a condition of null values column with reference to the primary key. How will i pass an array or string of values with a separator and fill in those null valued records(Primary key ID is the reference)? It should only fill in the values that i pass and not beyond(shouldn't update all the null valued records in the table). 

 

Thank you

 
 

1.jpg

 

The above screenshot doesnt give an expected output.

 

It just applies the values that i pass to all the records which satisfy the select & filter condition 

 

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (8,866)