Share
Report
81Hello Guys,
I'm trying to automate a process when a file is created in OneDrive. Below are some screenshots of the process.
In here I have created some excel scripts to be run when the file is created.
- Insert table (This includes the table name)
- Change number format
- Count the number of overdue days inside the report and insert into a new column
- Resize the table
- Finally it will trigger a Teams message to myself saying the file is created in OneDrive
Then get the table from the file in OneDrive.
In here I'm trying to add those table values to a SharePoint list
But unfortunately there are no values to add to theses columns in SharePoint list because the OneDrive file is created dynamically. Is there any other option which I can try?
TIA
Categories:
All responses (
Answers (
