web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / how to set location, d...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 82

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:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard