cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CP153319
Level 8

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
v-zhos-msft
Level 10

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
Super User
Super User

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!


CP153319
Level 8

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

Flow.pngHere is the flow.

CP153319
Level 8

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.

Super User
Super User

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!


v-zhos-msft
Level 10

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

CP153319
Level 8

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,036)