Compare SharePoint list and excel sheet and create/update items that match

[MohammedShaban]

I have a sharepoint list and an excel sheet that comes from Document library.

Now I need to compare the Title from the List with the Project Name from the Excel Sheet.

If they are matching then the existing item in the list needs to be updated with the values in Excel, if not a New Item has to be created with the values from Excel.

I tried many ways like adding a condition to check the Title with Project Name, if the condition is false then it is creating as many items as the items in sharepoint list.

Used a Filter array and compared Title with Project Name and used a condition empty(body(Filter_array)) is true create item, if false update item.

If there is no item matching the body of the Filter array is empty hence it is not creating item.

Please suggest me with the solution.

[v-bofeng-msft · Accepted solution]

Hi @MohammedShaban ,

I've made a test for your reference,

1\My SP list:

2\The Excel table

3\The flow

4\The Result

Best Regards,

Bof