I have a workflow that gets triggered on creation of a item on a SPO list. This list has a multi-choice field called "Required Event Support". You ahve the option of selecting multiple entries.
I need to be able to use PowerAutomate to send an email to the submitter, in a section of this email I need to add specific text based on what was selected in the "Required Event Support". If it was say option a and option d, the email notification will be appended with special notes for options A and D.
I've managed to parse the data out using "Append to Array" and the "Select" functions
Choices produces
[
"No support required",
"E-B",
"Gift A",
"Socials"
]
And the "Select" output is
[
{
"Value": "No support required"
},
{
"Value": "E-B"
},
{
"Value": "Gift A"
},
{
"Value": "Socials"
}
]
I've tried a IF + Contains formula to trigger an initialization of the variable with the specific text
similar to this if(contains(body('Select'),'E-B'),Yes,No), but this is not returning results.
I need to have PowerAutomate look through the above array and see that E-B was selected and then initialize the variable
Hi @kilaj1,
After the Select you could use a Filter Array action and check if the outputs is empty of that filter array action. If that is the case it has not found a match.
Below is an example.
After that Filter Array you could use an expression like below to check if empty.
if(empty(body('Filter_array')), 'Yes','No')
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
129 | |
50 | |
48 | |
35 | |
26 |