Unanswered

'The requested range does not exist in the sheet.' error when creating file in Sharepoint using Flow. Can anyone help on how to fix this?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to pull an attachment from Outlook and saving it to a Sharepoint folder using Microsoft Flow. The file does save, but when I try to open it, it gives me this error: "The requested range does not exist in the sheet." And when I try to open the file using the Excel desktop App, the file is blank (see screenshot below). Any thoughts on fixing this?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Could you please share your flow with detail steps? It seems the file has not been saved correctly. If you created the flow using template, please add a step "Gat attachment" below the trigger:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI @v-jefferni , here is my flow: trigger is when an email arrives:
then, I get the attachment and save it on the designated folder. Is there any additional step we should include?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

What is in the File Content field of Create file action? It seems like you have used wrong dynamic content. My flow steps are as follows:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni, Thank you for this. However, when I followed this flow, the saved file still gives me the same error mentioned above.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

It's quite strange... Have you checked the excel file from in the Email attachment? What type is this file? Can any other excel files created by this flow work correctly?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No