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,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Ragavendar Swaminatha Subramanian as our September…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 954 Super User 2025 Season 2
Tomac 650 Moderator
trice602 327 Super User 2025 Season 2
