cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CP153319
Helper V
Helper V

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

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
gamoraes
Memorable Member
Memorable Member

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!


Here is the flow.Here is the flow.

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


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

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,250)