Answered

From a MS Form Multi-select, in an email, embed only selected options which match a previous condition

(0) Share

Report

Posted on by NotMyRealName

Hello and very new to all this Power Automate stuff so be kind

I have an incident reporting form where users can select multiple options via checkboxes, and each option has a "key" (like [OSH]) at the end to identify how to route email notifications, which is achieved using a conditional control looking for that key.

In the body of the email, I only want to include the selected options that match they key.

For example; if the person completing the form selects multiple options with various keys of OSH, Spill, Security and Insurance....the control identifies that the OSH group needs to be emailed, and would see all the general details from the response like date, time, location....but I only want the selected options that match the control to be included in the email body.

The below returns all boxes checked, not just the one matching the condition.

All responses (2)

Answers (2)

Verified answer

NotMyRealName 12 on at

Like (0)

Report

Re: From a MS Form Multi-select, in an email, embed only selected options which match a previous condition

Thanks Rimmon!
That got me 95% there, only thing I had to do was add another Compose to get the body which I could then add to the email body. From here, it looks as though all I have to do is remove the ["xyz"] from around the responses when embedded which I'm pretty sure I can figure out.
Much appreciated
Verified answer

v-mengmli-msft on at

Like (1)

Report
Re: From a MS Form Multi-select, in an email, embed only selected options which match a previous condition

Hi @NotMyRealName ,

Do you want to filter options that contain specific characters? If your question is multiple choice, you need to turn the answers into an array and then filter through that array. Like this:
The user replies with Option1 and Option2 but I only want the option that contains 1.
1.Compose and Compose2 are used to convert result to an array.
split(outputs('Compose'),'"')
2.Filter array is used to filter the options which contains 1.
outputs('Compose_2') item() string(1)

Best regards,
Rimmon