Skip to main content

Notifications

Power Automate - General Discussion
Answered

When an item is created in a SharePoint list add a row to a table in Excel...

(0) ShareShare
ReportReport
Posted on by

I have an Excel file stored in OneDrive for Business with a table in it.

 

When an item is created in a SharePoint list I want to update the Excel file in OneDrive with the data from the item added to the SharePoint list.

 

I tried this:

  1. Trigger: When an item is created (SharePoint)
  2. Add row to a table (Excel for business) - Points to the file in OneDrive and should add the row
  3. Get file content using path (OneDrive for Business) - Finds the Excel file in OneDrive that was just updated
  4. Send an Email (Sends the Excel file from OneDrive to an end user)
  5. Delete a row from a table (Excel for Business) - This action deletes the row that I just added from the Excel file in OneDrive

This does not work properly at all - LOL

 

Curious if anyone has any thoughts on how I can make this work? When an item is created in a SharePoint list I want to grab that exact item (not any older items) and add a row to an Excel table in an Excel file stored on OneDrive for business.

 

Thank you

  • CP153319 Profile Picture
    CP153319 on at
    Re: When an item is created in a SharePoint list add a row to a table in Excel...

    I added a delay of 20 seconds after the "Add Row" control. Works perfectly now.

     

    Thank you for your assistance - Much appreciated!!

  • Verified answer
    v-zhos-msft Profile Picture
    v-zhos-msft on at
    Re: When an item is created in a SharePoint list add a row to a table in Excel...

    Hi @CP153319 ,

    I suggest you add a Delay action below the 'Add a row into a table' action to give some time for the data to synchronize.

    Then take a try, the issue is resolved on side.

    Capture13.PNG

    Best Regards,

    Community Support Team _ Zhongys

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

     

  • gamoraes Profile Picture
    gamoraes 1,040 on at
    Re: When an item is created in a SharePoint list add a row to a table in Excel...

    @CP153319  the dynamic content for selected item have a bug 😞

     

    You can use above the trigger a compose action to see and work with dynamic content, can you test it to see if work?

  • CP153319 Profile Picture
    CP153319 on at
    Re: When an item is created in a SharePoint list add a row to a table in Excel...

    Please note that the data from the SharePoint list is not being written to the file in Excel. However the file is Emailed to the end user - although it's blank.

     

    It makes sense that I'd add "Get Item" from SharePoint but when I do this there is no dynamic content available for me to grab the ID.

  • CP153319 Profile Picture
    CP153319 on at
    Re: When an item is created in a SharePoint list add a row to a table in Excel...

    Here is the flow.Here is the flow.

  • gamoraes Profile Picture
    gamoraes 1,040 on at
    Re: When an item is created in a SharePoint list add a row to a table in Excel...

    HI @CP153319

     

    What action doesn't worked?

     

    Can you post here a print of your flow and a history from it?

     

    Best Regards

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard