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
User | Count |
---|---|
22 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
45 | |
29 | |
25 | |
24 | |
24 |