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:
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
I added a delay of 20 seconds after the "Add Row" control. Works perfectly now.
Thank you for your assistance - Much appreciated!!
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.
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.
@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?
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.
Here is the flow.
HI @CP153319
What action doesn't worked?
Can you post here a print of your flow and a history from it?
Best Regards