You’re offline. This is a read only version of the page.
Announcements
78
Hello!
So, I have a SharePoint list with some entries. Now I need to add new entries to the SP list from an Excel Sheet (formatted as a Table). This is how I am doing it:
Now the Employee Code column have unique values.
If my excel sheet has only new rows (which doesn't already exist in the SP list), this flow works fine.
I want to configure it this way that if I have a duplicate value in my excel table (which is already there in the SP list), the flow should just skip it and go to the next.
How can I do this?
Thanks in Advance!!
Hello @ArshUser ,
In your Apply to each add a Get Items (SharePoint) action and filter items where Employee Code column equals Emp Code value in the loop. Then add a condition and check if any items were returned from the Get Items action. If No, only then Create Item in SharePoint List.
Please hit Kudos or Accept this Reply as Solution if it resolved your problem.
Share
Report
All responses (
Answers (
