Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 288

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

 

 

 

  • Verified answer
    fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: Create New Items in List Sharepoint from Excel but not items repeats

    Hi Community,

     

    My solution was this video

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

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: Create New Items in List Sharepoint from Excel but not items repeats

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

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: Create New Items in List Sharepoint from Excel but not items repeats

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

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: Create New Items in List Sharepoint from Excel but not items repeats

    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.

  • sudharsan1985 Profile Picture
    sudharsan1985 1,325 on at
    Re: Create New Items in List Sharepoint from Excel but not items repeats

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

     

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard