
Announcements
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?