Create New Items in List Sharepoint from Excel but not items repeats

[fgonzalez515]

Hi Community,

I want to create new items in my Sharepoint List from Excel, but I don't want to create repeat items.

How can I do my flow?

NOW

I WANT

Please your help, thanks

[sudharsan1985]

Hi @fgonzalez515 

Please look into the below video from Reza where he explains clearly on how to get the unique values from different datasource.

Power Automate Get Unique Values from Array | Distinct Items from Excel, SharePoint & Dataverse - Yo...

[fgonzalez515]

Hi @sudharsan1985,

I think I did not explain myself well.

In the video that you suggested, I understand how not to repeat items or obtain unique values, but it is from a table. But I want to know how to create a flow that can review the values ​​of the Excel row and see if they exist in the Sharepoint List and then Create new Items from Excel to Sharepoint and not create repeated rows.

You can help me with this.

[fgonzalez515]

I ask if someone from the community can help me with a flow for my problem.

[fgonzalez515]

I ask if someone from the community can help me with a flow for my problem.

[fgonzalez515 · Accepted solution]

Hi Community,

My solution was this video

https://www.youtube.com/watch?v=CRJXfVVhYrA&t=932s