Power Platform Community Forum Thread Details

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?

Categories:

how to set location, doc lib and file dynamically using ExcelOnline(Business) connector in automate?