Power Platform Community Forum Thread Details

Power automate novice here,

I've created a form for my company to track a certain checklist being filled out every week by individuals. I have a flow that makes sure they are up to date by emailing their manager the results of the checklist, and keeping track of it in an excel sheet and microsoft sharepoint list to have a digestible history of all submissions.

The only thing I am caught up on, and need help with is the following:

Two of the form questions require these individuals to submit images for proof they've done certain tasks. I'm attempting to attach these images in the emails that go to their manager, as well as add these images into EITHER my excel sheet history or microsoft list history. Adding them systematically into a folder in a sharepoint would also suffice.

When I add the dynamic content expression with those two question's answers into the email content, OR the "attachments" field in a "Send an Email V2" action it's just sending as a long string of text that DOES technically contain the URL to the image.

Just reaching out here to see if anyone has encountered a similar issue before and came up with a solution, or just has any advice as far as a direction to lean into?

Categories:

Building flows

HI,

Since your upload questions are required for proof (suggesting these are required questions in your Form), you don't need to check if they are empty in my example. In this example, I ask to upload one or more files in a single question.

So after your Get response details, initialize an array variable.

Again, skip the conditional action below and go directly to Parse JSON. Here you want to get the output for the question for the uploads (from the get response details latest run) and use that json as your schema example in your parse json action.

Her's the details of each action. Notice my question "Add a file", I've created a schema for the question by copying the output from the get response details and used the "generate from sample". Your schema will look very similar.

Because my question allows one or more file uploads, I use an apply to each and loop through each one and capture the file content. Then I append the details to my array variable attachments1.

Here's how I refer to the attachment content in my Send email action.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn