Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Advice on running flow optimally

Hello Power Automate Folks. 


I have a SharePoint list that i need to synchronize with a SQL View.  There are approx 400 items in the SPO list and the SQL View and i need to ensure the SQL data is in sync with the SharePoint Data. 

I tried to write a flow to do it, but the flow takes forever to run,  i believe its  because of the nesting in the Apply to Each (For Each SQL Value, for Each SPO List item Value,  if ID in SQL = ID in SPO List, then update SPO List item)


Am i looking at this thing wrong. Should i use Flow?, is there an more efficient way to achieve what i am looking to do?



Super User
Super User

@Vstar19 Please use filter query in SharePoint Get items. Inside SQL apply to use Get items with filter query.

Steps inside loop-

1. Use compose and pass ID from SQL loop

2. Use SharePoint Get items and use filter query: ID eq 'Output('Compose)'

idea is for each sql ID fetch SharePoint item with SQL ID.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /


not sure i fully understand. 

Do you mean use the ODATA filter in the get sharepoint items to filter by ID?



Helpful resources

Top Solution Authors
Users online (4,215)