PLEASE HELP - Get file content using path error

[cristineisles]

Hello,

I'm pretty new to Power Automate but it has been a day or so and I still haven't figured it out. I've looked online or YouTube and none of the solutions seemed to have worked. 

Essentially I have an MS Forms where users will fill out the information for approval/rejection. In that form, they will be able to add attachments (1/more). Once submitted, this will be automatically sent to the designated person for approval. At the same time, this information will be added into SharePoint Lists to see the current status of the request. Once its been approved/rejected, the approver should be able to leave comments and have the email sent back to the original requestor.

Currently, this is my flow:

There is a condition because depending on the requestor's answer in the form, the point of contact could vary.

I am running into this issue at the moment:

For Get file content using path, the path does exist

Is there a different way to work around this?

Do you also know how the approvers could leave a comment to be sent back to the requestor in the email?

[Expiscornovus]

Hi @cristineisles,

The answer to the question should have a list of attachments including details like the link and the guid. The trick is to convert it from a string to an array with a json function.

After that you can loop through this array and retrieve the details of each item/attachment with an Apply to Each.

One of those properties is the id of the file. You can use that value in a Get File content action (instead of a Get File Content using path).

Below is an example

1. Expression to convert string answer to array (change the id to your Forms upload attachments question id)

json(outputs('Get_response_details')?['body/re63869bd6ae04a5683cde0c7419c6578'])

2. Expression to retrieve File Id

item()['Id']

[cristineisles]

I'm not really entirely sure how to get the URID of an MS Forms? And can I still do Get file content using SharePoint instead of OneDrive?

[Expiscornovus]

Hi @cristineisles,

To figure out the ID for your MS Form upload question you can place a Compose action with the upload attachment question and use the peek code/code view feature of Power Automate.

Btw, a MS form is normally storing the uploaded files on the OneDrive for Business site of the person who created the MS Form, that's why I suggested to use the OneDrive for Business Get File Content action.

Unless it is a MS Groups hosted Form, in that case a Get File content using SharePoint might be needed.

See an example below.

1. Add a Compose and add your question to the Inputs.

2. Switch the Compose to Code View to see the id of the question.

[cristineisles]

@Expiscornovus Hello,

I followed the steps above, but maybe Im still missing something. When I tried running the flow it gave me an error which said "Flow run failed". Is there a better way to re-organize my flow?

And yes, the forms is hosted in MS Groups, so I did use the SharePoint Get File Content

[Expiscornovus · Accepted solution]

Hi @cristineisles,

Thanks for confirming that it is a groups form. In that case my suggested approach would be slight different. I would retrieve the path first (ServerRelativeUrl) and use a Get File Content Using Path action instead. 

Try something like below

1. Add a Send an HTTP request within the attachment question apply to each loop

a. Use as Site Address (this expression is used to retrieve the site address portion of the link)

join(take(split(item()['link'], '/'), 5), '/')

b. Use as URI (this expression is used to retrieve the file id portion of the link, a guid of 36 characters)

_api/web/GetFileById('@{substring(item()['link'], add(indexOf(item()['link'], 'sourcedoc=%7B'), 13), 36)}')?$select=ServerRelativeUrl

c. Use as Headers

{
  "Accept": "application/json;odata=nometadata",
  "Content-Type": "application/json;odata=nometadata"
}

2. Use a Get File Content using Path instead of a Get File Content

a. Use as Site Address

join(take(split(item()['link'], '/'), 5), '/')

b. Use as File Path (this expression is used to retrieve the file path portion of the ServerRelativeUrl field)

concat('/',join(skip(split(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['ServerRelativeUrl'], '/'), 3), '/'))