obtain in an array the value of the second column when filtering on the first column

Like (0) Share

Report

Posted on 22 Jan 2024 18:05:09 by GBO

Hello,

i have an array with 2 columns filtered on the 1st column. I try to obtain in a variable the value of the second column but i have a problem. My array has a first column with the name of the file and the second column with the email of the people i need to send the file.

In my flow, i need to put the email in the variable to be able to send an email with the file to the right people.

But i didn't success to obtain the email in my variable.

"Tableau1" is the array with my 2 columns

Please see below:

Someone could help me please?

Thank you

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni on 23 Jan 2024 at 06:34:50

Like (0)

Report

Re: obtain in an array the value of the second column when filtering on the first column

Hi @GBO ,

I didn't see any filter in your flow, where did you apply the filter?

Anyway, you can have an array of Emails from outcome of the action list rows present in a table using Select operator, switch to TEXT mode, select the Email column directly from dynamic contents. The outputs of Select is an array of Email column, use union to deduplicate and then use join to concatenate all Emails with semicolons to use in Send an Email action.

Best regards,

Was this reply helpful? Yes No