Hi everyone, I would like to create a flow that reads a SQL view, compares it with an existing sharepoint list (reading column Name) and inserts any new records added in Sql using daily recurrence and not the "Sql when an element is created" trigger. I was inspired by https://powerusers.microsoft.com/t5/Building-Flows/Selecting-Entries-from-SQL-Table-adding-in-Sharepoint-List-ONLY/td-p/73081 and https://powerusers.microsoft.com/t5/Building-Flows/Comparing-SQL-List-to-SPO-List-then-writing-Unique-SQL-items/m-p/276235#M28404 but the flow still goes into mistake. Can anyone tell me where I'm wrong or give me an alternative solution? Thank everyone in advance for their support
and here one of the many errors occurred..
@v-bacao-msft The configurations I tried are those of the links I reported.
Thanks so much for your support, I'm available for any clarification.
Hi @markent141 ,
Could you share the details of the Flow configuration and error message?
Which field do you use as a comparison field?
Please provide more details and we would provide proper workaround for you.
Best Regards,
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1