Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Update newly added list

(0) ShareShare
ReportReport
Posted on by 141

I have a flow where whenever user update an excel file (located in SP library), SP list will be updated and store the newly added data and send email to appointed user , the email contain data that is newly added . but the issue is whenever i run the flow, the email will contain every list in my SP . i wonder how do i set it to send only newly added data ?

norashura_0-1696316856217.pngnorashura_1-1696316885465.pngnorashura_2-1696316913529.pngnorashura_3-1696316962712.pngnorashura_4-1696317002091.png

norashura_5-1696317036283.png


Thank you in advance!

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Update newly added list

    @norashura  below are the details:

     

    1. Add SPItemID column to your spreadsheet (you wont be able to make it hidden as flow requires it to be visible, if you want to hide it probably you can make its width too small and move it to being last column in spreadsheet)

    2. Then in the "List rows present in a table" action add a filter query as below. This will get only those rows where SPItemID is blank

    SPItemID eq ''

    annajhaveri_0-1696491458341.png

     

    3. Within the loop after create item action, add Update Row action and configure it as shown in below screenshot

    annajhaveri_2-1696491687966.png

    In Key Column, provide the name of column which will uniquely identify the row the flow needs to update with the newly created SharePoint list item ID. Here you are updating the SPItemID with the newly created SharePoint list item ID so that again when your flow runs this row will not be processed by flow.

     

     

     

     

  • norashura Profile Picture
    norashura 141 on at
    Re: Update newly added list

    by any chance can you me an example of flow ?

  • annajhaveri Profile Picture
    annajhaveri 8,531 on at
    Re: Update newly added list

    @norashura  i think you will need hidden column in excel to store whether the row is added to SharePoint list or not and once items are added in SharePoint list you need to update the column to update that column.

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard