So I need to update / read some excel file save on SharePoint doc lib.
I am triggering the automate from an canvas app (embedded in D365 form)
So I know I can create an automate and I can pass in various strings to the automate. All good so far.
So on the action "add a row into a table", if I use static values from the dropdown for the Site location, doc lib and file etc...
it works fine.
But I need to set those dynamically, by passing in the SharePoint Site URL, Doc Lib name and the file doesn't seem to work at all...
Any ideas? I assume it's possible to set it dynamically otherwise we won't have the option to enter dynamic values...
If that is possible then what is the correct syntax please?


Report
All responses (
Answers (