Error 404 when querying the tables in an excel file

[bouillons]

Hi, I have a strange bug in a very simple scenario with a power app that triggers a flow. In the power automate flow I copy an excel file from sharepoint (empty, except for a table) to the user's OneDrive. Next I inject the data sent from PowerApps (a JSON table) into a table in the newly created Excel document. When I do this with my user, it works flawlessly. When another user executes the same flow, I get a 404 error in the Get Tables step.

{

  "status": 404,

  "message": "The resource could not be found. clientRequestId: 096ce5f4-983e-407f-b636-bc0fcb0e5b02 serviceRequestId: 75a743e1-3853-495b-bf39-f3fd2e065a74",

  "error": {

    "message": "The resource could not be found."

  },

  "source": "excelonline-ne.azconn-ne.p.azurewebsites.net"

}

The file clearly exists in the user's OneDrive, and it does contain a table, so I don't know what I'm doing wrong.

[manuelstgomes]

Hi @bouillons 
 

Assuming that you're sharing the Flow, Although another person is running your Flow, the file won't be created in their OneDrive. Instead, it will be created in yours since it's your connection that is being used.

Please check that when another user runs the Flow, the "Create a target file in OneDrive" step is executed, and the file is created?

Another issue could be the time to create the file. When you trigger the create the file, OneDrive may take a few seconds to do it. But Flow will jump right away to the following action, so it will try to fetch the file, and it doesn't exist (yet). This is one of the sporadic times where I recommend using a "Delay" action between both actions. The few milliseconds used to authenticate and verify that the o...

Can you please try and let me know if this solves your problem?

Cheers

Manuel

------------------------------------------------------------------

If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?

Otherwise, reply to it, and the community will do its best to help you.

[bouillons]

Thank you, in fact, the flow is triggered by another end user from a PowerApp canvas app (Wissam El Bidari in the example below). I was under the assumption that the flow would then by default use the end user's own connection to OneDrive, which seems to be the case, given that the file is clearly created in the user's OneDrive (url is multipharmagroup-my.sharepoint.com/:x:/r/personal/wissam_elbidari_multipharma_be1/_layouts/15/Doc.aspx?sourcedoc=%7B802CAE22-2AD5-4B71-8A9C-175CF83BE090%7D&file=Multipharma%20Points%20of%20Sales_2021-08-04.xlsx&action=default&mobileredirect=true).

Adding the delay (10 seconds) did not change anything, but looking at the output of the create file I do see a difference between the Last modified by and Connection users. How can I force the flow to use the connection of the end user ?

[manuelstgomes]

Hi @bouillons 

To select the connection, you can press the 3 dots and set it like this:

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

[bouillons]

What I need is a dynamic connection that will connect to the OneDrive of the user that is executing the flow. Note that the end user does not interact with the flow directly, this flow is called from a Power Apps Canvas App.

[bouillons]

I'm still facing this issue. The Flow is triggered by the end user. The file is created correctly in the end user's OneDrive. A subsequent action to retrieve information from the file (ExcelForBusiness GetTables command) returns a 404 error. When I execute the app myself, it works correctly (I am the owner of the app and of the flow).

I don't see what more I can do. Please help,

Stephane

[DariuszJ]

Hi,

I faced similar issue. Check how many rows there is in the table (if there's any empty rows). Flow seems to have some threshhold, above which flow may fail due to too large table.

[bouillons]

Thanks but that's not it. I add a "get tables" and it fails even though the excel only contains one empty table. I opened a support ticket with Microsoft and await their repro.

[bouillons · Accepted solution]

I raised it with Microsoft and it is By Design. I created a feature request here Impersonate End User in Excel for Business Connect... - Power Platform Community (microsoft.com)

Please Upvote if you also need this scenario.

[MayAlejandro]

Hello,

@bouillons did you get a solution for it? I am facing exactly the same problem without solution yet. I was not able to open the link you shared to vote about it...

Does anyone know the solution or any workaround? Thanks