I am trying to build a flow that uses an Excel sheet as the source stored on Onedrive. The Excel sheet has a few columns but I wish to verify if the information in two of those columns match on the SharePoint list to avoid duplicates. If the item exists I wish to do nothing but if it doesn't I wish to create the item. I have tried using the odata to filter the SharePoint but had no luck on creating the flow. I would like some ideas on how to accomplish this task. I will appreciate all your help.
You need to use the SharePoint action ‘Get Items’ and the Excel action ‘List rows present in table’. Then, create a condition to check if the row is equal to one of the SharePoint items. You need to iterate through every row for each item in SharePoint. If you find a match, do nothing; if not, use the ‘Create Item’ SharePoint action.
It should look like this.
Hope this helps.
Anthony.
Was this reply helpful?YesNo
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.