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

[MateiC]

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.

[Anonymous]

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

Thank you