cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MateiC
Advocate I
Advocate I

Excel action Get Tables error, string is invalid for File field

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.
 
I then tested the Get tables action with Location and Doc Library manually selected, and the File field filled out through dynamic contect, which again triggered the error.
 
Finally I tried typing out the file name in the field, which again triggered the error.
 
From all this I assume that the File field is the only one that needs some kind of object type passed to it, instead of a string. My question now is if anyone understands the issue and has a workaround for this limitation, if I could Compose a string into the object type the File field expects.
20 REPLIES 20
Anonymous
Not applicable

YES !!  Using 'File Identifier' solved my issue perfectly.

Thank you

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (76,751)