Hi @ThoSt
In my understanding, you want to have those specific email addresses according to the value in the ‘array’ column.
If I’m misunderstanding your need, please could you tell me whether there is another array variable? Is it an initialized variable in Flow using the step ‘initialize variable’? And could you take a screenshot of detailed steps of your flow?
If I’m not misunderstanding your need, you could try the flow as below:
The action ‘Condition’ only supports string and integer, if you just use [“test1”] here, the flow will automatically recognize it as array and will get error. So, [“test1”] should be converted into string.
The detailed steps for ‘If yes’ in ‘Condition’:
The functions used:
outputs('List_rows_present_in_a_table')?['body/value'][0]['email addresses']
outputs('List_rows_present_in_a_table')?['body/value'][2]['email addresses']
concat(outputs('Compose'),';',outputs('Compose_2'))
The meanings for these three functions here:
Compose: get the email addresses from A2
Compose2: get the email addresses from A4
Send an email: combine two email addresses separated by semicolon
The detailed steps for ‘If no’ in ‘Condition’:
The detailed steps for ‘If yes’ in ‘Condition 2’:
The functions used:
outputs('List_rows_present_in_a_table')?['body/value'][0]['email addresses']
outputs('List_rows_present_in_a_table')?['body/value'][1]['email addresses']
outputs('List_rows_present_in_a_table')?['body/value'][2]['email addresses']
concat(outputs('Compose_3'),';',outputs('Compose_4'),';',outputs('Compose_5'))
Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
