Answered

Office Script Returning File Format Error

(0) Share

Report

Posted on by Unlighted7406

Hi Power Community!

I have a flow which takes an email attachment (.XLSX) and saves it to a SharePoint folder and grabs some metadata. I then have a condition which checks that the file is indeed the correct format, and if so, run an Office Script that functions normally when run manually. However, when running the Script via the flow, I receive a BadRequest error:

"message": "The file format is not recognized. Please check that the selected workbook is valid.

I know it's valid because I can open the file manually both with Excel Business and the standalone app, and the condition returns "true" for verifying the file type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

I felt that it might be too soon after file creation and that the server might need time to "load" the file so to speak, so I added a two-minute delay before the script runs, with no change in error message. Please tell me what information I need to provide for troubleshooting. Any ideas would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Unlighted7406 20 on at

Like (1)

Report

Solved! Apparently, the Office Script connector is expecting an identifier that includes the file type even if the file explicitly has the extension in the name and a condition has already confirmed the correct type. Swapping out the dynamic content "name" with "id" made it work, and no delay was required.

Was this reply helpful? Yes No
dquintanilla 2 on at

Like (0)

Report

Could you elaborate on how you fixed this? I am having the same problem, but I don't completely understand the solution

Was this reply helpful? Yes No
tjlyons 10 on at

Like (1)

Report

So instead of using a dynamic name (whether it's a variable or collected from a "get" action), you need to get the "id" of the file you want to modify. In my case, I was creating a new file and using the variables for the new filename. When I retrieved the "id" from the results of the create file action, it worked:

Was this reply helpful? Yes No
sami_mrs 20 on at

Like (1)

Report

It is very strange about getting the following error when using run script action in power automate.

The file format is not recognized. Please check that the selected workbook is valid.
clientRequestId: 727360b6-ef5e-4a52-aaf4-098539b6384a

There is no solution found. Some Excel files works well. Some Excel Files do not work and show the above error.

Here I have seen only vague solutions. Nothing is useful.

It is wasting time to use Power Automate for setting flow for some part of work.

Also, not have any proper way of content from Microsoft about debugging issues.

Was this reply helpful? Yes No
sami_mrs 20 on at

Like (0)

Report

Your suggestion is not useful. Till Getting same error

Was this reply helpful? Yes No
sami_mrs 20 on at

Like (0)

Report

using id is not a solution. it is also throwing same error.

Was this reply helpful? Yes No
netptl39 4 on at

Like (0)

Report

Solution: move the .xlsx to a shsareoint site with a smaller number of files.
I had a flow working perfectly and one that didn't.
Once I migrated to a smaller site the automation started working on first test.
My guess is that the searching for the file ID "times out" either becasue of the high number of files or depth of the location.

Was this reply helpful? Yes No
prashantch 4 on at

Like (0)

Report

Hi All,
I have faced the similar issue, and found the solution, below is the link my possible solutions.

Thanks

Was this reply helpful? Yes No