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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,824)