I've encountered a behaviour I don't understand with the Excel action Get Tables. I'm aware that this is a preview action, thus it's expected to raise issues.
I manually fill the Location, select the Doc Library from the UI dropdown, the brows for the file location through the UI dropdowns. This correctly grabs the file.
I need a flow that uses logic to determine which Excel file it needs from a Library, and then get that file from the Library. I created a SharePoint list that contains 3 columns, for the Location address, Doc Library name and File name.
If I then fill in the Get Tables fields with dynamic contect from this list, I get an error:
{ "status": 400, "message": "The parameter 'file' has an invalid value '/Translation.xlsx'." }Translation.xlsx being the file name.
YES !! Using 'File Identifier' solved my issue perfectly.
Thank you
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.
User | Count |
---|---|
25 | |
23 | |
9 | |
9 | |
7 |
User | Count |
---|---|
41 | |
35 | |
24 | |
21 | |
13 |