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.

I have the same question (0)

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

Was this reply helpful? Yes No