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:
- Trigger: When an item is created (SharePoint)
- Add row to a table (Excel for business) - Points to the file in OneDrive and should add the row
- Get file content using path (OneDrive for Business) - Finds the Excel file in OneDrive that was just updated
- Send an Email (Sends the Excel file from OneDrive to an end user)
- 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
