(SharePoint) Getting file content using path 404 Error

(0) Share

Report

Posted on by Valther

I have a problem with a flow, it waits for the responses of an MS Form and the adds a new item to a SharePoint list.

Then, it reads the uploaded file and attaches it to the created item in SharePoint. (ss_001)

It works fine like the 90% of the time, and the other 10% it would fail in with an error that the file that we are trying to attach is not found (404 error) (ss_002)

- I have tried refreshing the connections, removing, re-adding the connections with no luck.
- I tried with the relative and the absolute path and both fail with a 404 error.
- I have copied the URL from the flow with error and pasted the URL in the browser and the attached file opens correctly.
- If I check the folder where all the files are being uploaded, the file is present in the folder.
- I have also tried the solution in this page: (ss_003)
https://elliskarim.com/2022/01/17/how-to-send-microsoft-forms-file-uploads-to-an-approval-workflow-using-power-automate/

But it would throw a 404 on all the files uploaded for 100% of the cases.

I have used an MS List Form previously, and that worked 100% correct all the time, but we decided to move to an MS Form as it would let customize the Form and validate the fields.

What else could be done in this case?

Thanks for you help and attention!

Categories:

Building flows

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

11manish 1,271 on at

Like (0)

Report
Copy link

Link copied!

It seems that the 404 error occurs because the flow runs before the uploaded file is fully available in storage.

This is a timing issue with Microsoft Forms file uploads.

The solution is to introduce a delay or retry mechanism (preferably a Do Until loop) before attempting to access the file.

Was this reply helpful? Yes No
Pstork1 69,323 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you using a Group Form for this? I'm assuming you are since you are looking for the File Content in SharePoint. If it was a single form it would be in OneDrive for Business.

Having said that can you show me the formula you are using for your file path? The link provided will have a SharePoint site URL that needs to be removed from the front of the link before you can use it as a path.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Valther 48 on at

Like (1)

Report
Copy link

Link copied!
Yes, it is a Group Form.

Now that you mention it, that should be the reason why the OneDrive steps won't be of use here.

The response from the Form is set to a Temp variable to check the content, then the attachment attribute is parsed to get the JSON from it.

The Body of this JSON is passed to the "Apply to each" step.

And finally, this is the Formula for the "Get file content using path":

{ "inputs": { "host": { "connectionName": "shared_sharepointonline", "operationId": "GetFileContentByPath", "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline" }, "parameters": { "dataset": "https://contoso.sharepoint.com/teams/MySite", "path": "@items('Apply_to_each')?['link']", "inferContentType": true }, "authentication": "@parameters('$authentication')", "retryPolicy": { "type": "fixed", "count": 4, "interval": "PT20S" } }, "metadata": { "operationMetadataId": "f6209557-5239-48b6-b61f-47afe655d5a6" } }

The File Path used in this step, looks something like this:
https://contoso.sharepoint.com/teams/MySite/Documents/...

Thanks and regards!

Was this reply helpful? Yes No
Verified answer

Pstork1 69,323 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can't use the link property directly in the Get file content with Path because it is the full url, not the relative url to the file. Here's a screenshot of an example I use with a group form. In the Compose you can see I am replacing the Site URL with a null value to get the relative address of the file in the site. Since its expecting a relative path to the file that's an essential step. In fact, I'm not sure why its working at all if you don't strip out the URL.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Valther 48 on at

Like (1)

Report
Copy link

Link copied!

Thank you all for your help.

Both recommendations have been applied and the flow is now 100% functional.

Best regards!

Was this reply helpful? Yes No