Dynamic file path to get Excel workbooks

Like (0) Share

Report

Posted on 10 Nov 2020 18:10:16 by xavierpamment

Hi guys

I am fairly new to Power Automate and I'm currently just playing around with the capabilities of Flows.

I'm trying to create a Flow that is applicable to multiple different Excel workbooks with similar, but slightly differing names.

I read online that the Excel 'Get workbooks' step does not take a mixture dynamic content and strings in it's 'File' entry field, so I created a string variable to generate the file path, and then I places that variable into the Excel step, as show below:

However, when I run the flow, I get an error message that doesn't seem to make sense:

I have double, even triple-checked, and the file with that EXACT name (case sensitive) in the given path exists. I am at an ends as to what to do from here.

Any help or suggestions would be thoroughly appreciated.

All responses (1)

Answers (1)

Verified answer

ChristianAbata 8,949 Most Valuable Professional on 10 Nov 2020 at 20:00:52

Like (1)

Report

Re: Dynamic file path to get Excel workbooks

hi @xavierpamment what you need is not a path is an ID. so you can follow this blog that shows you how to get the ID from a file using HTTP sharepoint API request. see

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-How-to-access-Excel-with-a-dynamic-path/ba-p/462763