You can use the When an item is modified (V2) trigger to monitor the SQL if some data updates.
You can use the Apply to each action to loop through all the rows get from OneDrive, then compare them use the Condition action.
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have not used this trigger before. Would this continuously monitor my SQL table for changes? My fear is that this table is pretty active so it would be executing quite often. When this trigger occurs would it only look at the single row where the data change occurred? I was thinking triggering this on a time schedule a few times a day would be adequate.
Also, I agree that a condition would be best and that the OneDrive Excel Table should be used for comparison but I'm a little unsure of how to tie it all together. What action would be used for this comparison of the OneDrive table to the SQL table? Get Rows (Excel connector)?
I look forward to any additional help.
If you use the "when an item updates" trigger, then yes, your flow would execute every time a record updates, for each individual record. If the table updates frequently, then it would probably not be the best alternative. Does your SQL table have some kind of timestamp that indicates when a record is updated to a status you want to watch? If so, then I might suggest a scheduled flow that looks at the timestamps with a SQL WHERE clause. It wouldn't be a perfect solution due to the vagueries of timestamps, but it would run far less often.
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!