cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Dynamic Location in Excel

Hi everyone!

 

I face the problem with determining Location in Excel (Bussines).

I want to keep URL in var and connect by this to Excel file in Sharepoint.

 

According to the documentation, it is possible:

Select from the drop-down or specify one of the following:

- "me"

- "SharePoint Site URL"

- "users/someone's UPN"

- "groups/group Id"

- "sites/SharePoint Site URL:/teams/team name:" (the colons are required).

 

But I don't understand how it is work...

"Sharepoint file was not found"

My arg:

https://company.sharepoint.com/sites/Automation

Documents

252fTestFolderApps%252fTO.xlsx

TableName

 

image.png

Has somebody solved this problem?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Dynamic Location in Excel

@Mikhail49 

 

Hey Mate, I have come across this problem is the past and I had to Reverse Engineer a little as the Drive ID always complaining. 

 

What I did was create a dummy file, filled in all the correct values and ran the Flow and after the Power Automate executed, I clicked in raw inputs and copied the drive ID.

 

 

Untitled1.png

 

Executed the Power Automate and got correct results.

 

Untitled2.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

View solution in original post

4 REPLIES 4
Highlighted
Dual Super User III
Dual Super User III

Re: Dynamic Location in Excel

Hi!

For location, you have to click on the drop down menu, at the bottom of it you will find the option: 'Enter custom value'.

Once selected, you can either type your site URL or add it from the dynamic content menu

Now, the point is this way you cannot select file by navigating through the folders on the target site, since FLow editor does not got the site URL yet. As far as I understood, this is your challenge, right?

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Resident Rockstar
Resident Rockstar

Re: Dynamic Location in Excel

@Mikhail49 

 

Hey Mate, I have come across this problem is the past and I had to Reverse Engineer a little as the Drive ID always complaining. 

 

What I did was create a dummy file, filled in all the correct values and ran the Flow and after the Power Automate executed, I clicked in raw inputs and copied the drive ID.

 

 

Untitled1.png

 

Executed the Power Automate and got correct results.

 

Untitled2.png

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

View solution in original post

Highlighted
Frequent Visitor

Re: Dynamic Location in Excel

Great! It works! Thanks!

 

 

Highlighted
Resident Rockstar
Resident Rockstar

Re: Dynamic Location in Excel

Hey Mate,

 

I am glad that we could resolve your problem. Have a wonderful weekend 🙂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Users online (5,905)