Power Platform Community Forum Thread Details

I have created an approval flow in Power Automate that is triggered by a Microsoft Form submission. I want to include a link to the submitted form in the email sent to the approver so they can easily review the responses and any uploaded files.

However, when I try to add the supporting document as a dynamic item in the email content, I get a #404 error.

Copilot suggest me below link for MS form submitted, but it fails to load:-

<a href="https://forms.office.com/Pages/ResponsePage.aspx?ID=YOUR_FORM_ID&responseId=@{triggerOutputs()?['body/resourceData/responseId']}">Click here to view your submission</a>

Is there a way to:

Add a direct link to the submitted form response in the email?

Include uploaded files or links to those files for the approver to access?

Any guidance or examples would be greatly appreciated!

Categories:

General topics

{Moved from the Power Apps forum}

Normally I would build a flow to grab the form response, save it to a SharePoint list and - using a get file content action - attach the uploaded file to the Start and Wait for an Approval action. Then when the item is approved or reject save the details of the approval, date and outcome back to the same item in the list. At my company that is best practice both from a audit perspective and so that you have a separate copy of the response and a record of the approval.

However, it is possible to add a direct link to a form response in an email. You should make the form a group form with your approver in the group so that they can access each form response.

After the trigger and the get response details action, run the flow so that you can grab the id of the first question as you'll need this later.

Add a compose action and paste in the question ID you copied above. Why it needs this and why only this one is a mystery.

Then add another compose and select Response ID from the dynamic content box.

Next add another compose and enter the expression sub(outputs('ResponseID'),1) into the expression tab of the dynamic content box and add the expression to the compose. You will need this because the ridx value is always 1 less than the response ID unless you've deleted rows from the response spreadsheet behind the form.

Next, add another compose and paste in the link address (mine was a duplicated form so yu might need to replaceShareFormPage with NeoPortalPage:

https://forms.office.com/Pages/DesignPageV2.aspx?origin=ShareFormPage&subpage=design&m2=1&id=VUIjPQ_iBUKIpZZYpAKZm2tQtOivi1hPg51lh-vO1rRUQ0ozQllVQzA0U0NGUDA4MTJSSTBQSEhFVC4u&analysis=true&tab=0&topview=SurveyResults&qid=@{outputs('qid')}&ridx=@{outputs('ridx')}

selecting the relevant compose outputs from the dynamic content box.

Finally, select code view </> button in the email header and add in the following html tags and select the outputs from the Link compose.

When you submit a form the email comes in and the link takes the person directly to the submitted item.

Instead of the send an email action you could have a start and wait for an approval action and add the outputs of the link compose into the item url field.

The link in the email takes the user directly to the submitted action.

But doing it via a SharePoint list would definitely be my preference.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)