Answered

Append to Array only if condition is met

(0) Share

Report

Posted on by enunez1998

Hello, is it possible to make an Append to Array Variable conditional? For example I would only like their email appended to the variable only if they have 'District' selected on the source list.

I have the same question (0)

All responses (3)

Answers (1)

JonDoesFlow 1,304 on at

Like (1)

Report

Re: Append to Array only if condition is met

Yeah create a condition which contains District and then do what you need to do if true ?

Was this reply helpful? Yes No
enunez1998 6 on at

Like (0)

Report

Re: Append to Array only if condition is met

Sorry should've been more specific in asking my question. Where exactly in the flow should I add the condition?

I tried adding in the condition right after the Apply To Each and it errors out each time. Also to note when I added in the condition to look at Building Value it automatically added another Apply To Each.

Error: The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,059 Moderator on at

Like (1)

Report
Re: Append to Array only if condition is met

The easiest way is to use the Filter Query within your Get items so it only brings back items where the Building is equal to District.

For this example, I have the following list. Note that I've just renamed the Title field to Email which looks the same as what you have done.

Below is the full flow. I'll go into each of the actions.

Get items retrieves the items where the Building is equal to District. This will work even for a multi-select Choice field.

Building eq 'District'

Select retrieves just the Emails (Title field) into a simple array.

Join uses the output from the Select and joins the emails with a semi-colon ;

If we ran the flow now we would get the following output.

You can then use the output from the Join in your Send an email notification action.

Was this reply helpful? Yes No