Advice on running flow optimally

[Vstar19]

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 

[Hardesh15]

@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

[Vstar19]

not sure i fully understand. 

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