Skip to main content

Notifications

Power Automate - Building Flows
Answered

Update and Create items from Excel table to Sharepoint list

(0) ShareShare
ReportReport
Posted on by 290

Hello Community,

 

I have an Excel table that I want to update and create new items in my Sharepoint list, when new data is registered in the Excel table.

My problem with the flow is not when I update but when I want to create new items to the Sharepoint list, I think I made a mistake with the flow, which I cannot identify, since multiple items are created and even repeated.

 

My Table Excel

fgonzalez515_0-1628449164222.png

 

My List Sharepoint

fgonzalez515_2-1628449386145.png

 

My flow Update ( I don´t have problem )

fgonzalez515_0-1628453769537.png

 

 

My flow Create items ( I have problem )

fgonzalez515_1-1628453799061.png

 

 

Please your help, thanks.

 

 

  • fgonzalez515 Profile Picture
    fgonzalez515 290 on at
    Re: Update and Create items from Excel table to Sharepoint list

    Thanks @v-LilyW-msft 

  • Verified answer
    v-LilyW-msft Profile Picture
    v-LilyW-msft on at
    Re: Update and Create items from Excel table to Sharepoint list

    Hi @fgonzalez515 

    Sorry,forgot to show you the content of the Filter query in Get items action.

    List rows present in a table hasn't applied a Filter Query.

    Get items applied a Filter Query as below

    vLilyWmsft_0-1628485494246.png

    Best Regards.

  • fgonzalez515 Profile Picture
    fgonzalez515 290 on at
    Re: Update and Create items from Excel table to Sharepoint list

    Hi @v-LilyW-msft,

     

    A question, in "List rows present in a table" and "Get items" you applied a Filter Query?

     

  • v-LilyW-msft Profile Picture
    v-LilyW-msft on at
    Re: Update and Create items from Excel table to Sharepoint list

    Hi @fgonzalez515 

    I did a test on my side, and can create a new item to the Sharepoint list if the list hasn't the row.

    You can take a try to change your create new items part to the steps shown in the figure below:

    vLilyWmsft_0-1628472565164.png

    vLilyWmsft_2-1628472640731.png

    vLilyWmsft_3-1628472667257.png

    This is my test excel

    vLilyWmsft_4-1628472925811.png

    This is my test list

    vLilyWmsft_5-1628472982637.png

    After flow runs, the D\E\F will be created in the list.

    vLilyWmsft_6-1628473192364.png

    Hope the content above may help you.

    Best Regards

    If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

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,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard