cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fgonzalez515
Helper V
Helper V

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

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

fgonzalez515_1-1629438569666.png

 

 

I WANT

fgonzalez515_2-1629438667313.png

 

Please your help, thanks

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
fgonzalez515
Helper V
Helper V

5 REPLIES 5
sudharsan1985
Solution Sage
Solution Sage

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...

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

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
Helper V
Helper V

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

fgonzalez515
Helper V
Helper V

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

fgonzalez515
Helper V
Helper V

Hi Community,

 

My solution was this video

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,175)