cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate IV
Advocate IV

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

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.

 

View solution in original post

6 REPLIES 6
Highlighted
Power Participant
Power Participant

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


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Highlighted
Advocate IV
Advocate IV

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.

Highlighted
Advocate IV
Advocate IV

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.

Highlighted
Power Participant
Power Participant

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?


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Highlighted
Solution Sage
Solution Sage

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.

 

View solution in original post

Highlighted
Advocate IV
Advocate IV

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

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,152)