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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David_MA 14,085 Super User 2026 Season 1 on at

Like (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'], ''))))

Was this reply helpful? Yes No
Suggested answer

Meekou 200 Moderator on at

Like (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

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (1)

Report
Copy link

Link copied!

Try this:

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

Was this reply helpful? Yes No