Power Platform Community Forum Thread Details

Hey everyone,

I have created a form in MS forms which has totally around 10 questions.
Please note that out of these 10 questions, there are 2 questions where the user needs to upload files and only 1 of them is mandatory.
I am trying to create a flow in Power automate where:

I receive automated email in outlook at a specific email address
This email should contain only the questions and answers which were attempted
The excel/pdf/word files uploaded by the user should be visible in the email as a short descriptive and clickable hyperlink

I could really use some detailed guidance here as I have tried a whole bunch of stuff which chat gpt has suggested so far, but haven't been successful in meeeting all the above mentioned requirements. Tried Copilot too but that was a disaster.

Thanks a ton in advance and looking forward to your suggestions.

Categories:

General topics

Hi,

A. Trigger
When a new response is submitted
Form ID: Your Form

B. Get response details
Get response details
Form ID: Your Form
Response ID: Response ID

C. Parse the uploaded files questions JSON
For each file upload question, the answer is a JSON array string.

Example:

[
{
"name": "filename1.pdf",
"link": "https://yourtenant-my.sharepoint.com/..."
},
...
]
Use Parse JSON action on the file upload question response.

Use the following sample schema (adjust according to your JSON):

{
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"link": {
"type": "string"
}
},
"required": ["name", "link"]
}
}
D. Compose the email body step-by-step
Initialize a variable, say emailBody, string type, set it initially empty.

Use Append to string variable action conditionally for each question:
If question answer is not empty:
Append:
Question 1: Answer 1 
For file upload question, after parsing JSON, append clickable links like:

html:
Uploaded files: 
<a href='filelink1'>filename1</a> 
<a href='filelink2'>filename2</a> 
E. Send email action
Use Send an email (V2) action,

To: your specific email,

Subject: e.g. "New Form Submission from [Responder Name or ID]",

Body: use the emailBody variable,

Make sure Is HTML option is set to Yes.

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
Regards,
Riyaz