cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vstar19
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?

 

Thanks 

2 REPLIES 2
Hardesh15
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 /Gopenly.in

 

not sure i fully understand. 

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

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,230)