Power Platform Community Forum Thread Details

On Forms (see attached), respondents have the option of selecting several items that correspond to files stored in a OneDrive folder. Once they make their selection and submit the Form, I need all of the files they requested to be emailed. I know how to create a flow that sends 1 attachment when the respondent selects 1 Form item only. I cannot figure out how to write a flow that will pull multiple files if the respondent requests more than 1 file. For example, they select 'Box Car' and 'Animal Walks'. Each time I try selecting more than 1, the flow skips 'Get File Content' and 'Send Email' (see attached screenshots).

It seems like it has something to do with creating an array and using parse JSON but I'm very new to this and haven't been successful.

The AI in power automate suggested a flow using HTTP but I don't have access to that feature.

Categories:

Building flows

Good Afternoon,

To send multiple emails we can do the following:

Create a flow based off the responses

First "Initialize Variable" action and do an Array for the type.

do a conditional check like is A = to Yes or B = to Yes for each file and so on for each file have a pre-assigned file to use action:

"Get File Content" on put the correct site location and the Id for the current file based on the "Condition" for the question you are currently on.

Now that you have the content of your file and the array exist we need to add that file and that content to your array. It will look like the following:

Your name in this step will be the name of your file you pre-determined!

Body will be the dynamic value like above from the previous step.

At this point continue to the next step in the process which will be the same conditional statement. Which you will then repeat the steps above for.

The only other thing that I can think of in this solution is you may need a base case for if they choose no files and that when you email the user with their files you click on the array to convert from dynamic content to an array and select your array value and you should be done!

If this answers your question pick me as the solution. If you still require assistance, be sure to comment I will circle back around to assist!

Have a great day!