Hi all,
tl;dr: The "Get file content using path" action sucees for png and pdf file, but fails for xlsx, docx, pptx files.
The general aim of the flow is to attach a file that was shared via MS Forms to an MS List entry.
As both, the MS Forms and the MS List, are "owned" by a SharePoint instead of an individual solution explained in this video (from 29:38 onwards) was applied: Video
The overall flow structure is:
The error received is:
The full file content box says:
"status": 404,
"message": "File not found\r\nclientRequestId: ba4a063d-7081-44e9-859f-3f9c6864f708\r\nserviceRequestId: ba4a063d-7081-44e9-859f-3f9c6864f708"
For a successful run, it would say:
"$content-type": "application/octet-stream",
"$content": "/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAM...
The part where the error occurs is:
The json is the standard json(outputs('Get_response_details')?['body/question_id']).
The expression used for "File Path" is item()?['link'].
The "Infer Content Type" was checked with Yes and No - error occured in both cases.
When I run the flow with a file with format e.g. png or pdf, everything works as expected and the "Get file content using path" runs successfully. When I run it with a file (same name just different format) of type docx, xlsx, pptx the flow fails with the error "NotFound". The File Path that is shown in the action, however, seems correct. If I manually copy it into my browser, the file opens (thus the assumption that the file path is correct).
Does any experience a similar issue or has an idea how to either change the flow or has an idea of what should be done to further identify the root cause?
Thanks
