Concatenate non empty dynamic values in an email

(0) Share

Report

Posted on by ShadM

Hi,

In Power Automate, I wanted to list all non empty outputs in an automated email separated by commas. So for example, if there are 3 outputs that and one of them is empty (let's say Value3 is empty) then I want to list the 2 non empty values as: Value1, Value 2. Currently when I use the concat function it lists the values with unnecessary commas for the empty values: Value1, Value2,,

How do I fix this?

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

Suggested answer

David_MA 15,585 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Look into the coalesce expression as I think that can solve your problem: Power Automate Coalesce Function Explained

I think you'll need something like this: concat(coalesce(items('Get_items')?['Value1'], ''), if(equals(coalesce(items('Get_items')?['Value2'], ''), ''), '', concat(',', coalesce(items('Get_items')?['Value2'], ''))), if(equals(coalesce(items('Get_items')?['Value3'], ''), ''), '', concat(',', coalesce(items('Get_items')?['Value3'], ''))))
Suggested answer

Meekou 200 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
For removing empty items before join multiple items, you could try options below:

You could try to loop the outputs, then check if the outputs is empty, if not, concat the result

Try to create array based on the outputs, and then filter the output by not empty, and finally join the result

For the second option, here is a simple demo:

Use multiple Compose action to mock your multiple outputs

Add Filter Array action to filter outputs

Here is the code for above

{ "inputs": { "from": "@createArray(outputs('Compose1'),outputs('Compose2'),outputs('Compose3'))", "where": "@not(equals(item(),string(null)))" } }

Create Reusult

Here is code view

{ "inputs": "@join(body('Filter_array'),',')" }

Regards,

Meekou

Private Support
VictorIvanidze 13,083 on at

Like
a
(1)

Report
Copy link

Link copied!

Try this:

replace(concat(items('Get_items')?['Value1'],',', items('Get_items')?['Value2'],',',items('Get_items')?['Value3']),',,',',')