Answered

How to use Concat function when there are empty values (I have 3 fields and I don't want to concat then when empty)

(0) Share

Report

Posted on by naijacoder1

Hi All,
I have around 3 fields from a sharepoint list e.g returning "Boy", "Girl", "Daddy".
I would like to have then concatenated into a single field like so Boy.Girl.Daddy - FYI i also need the dot in that format

If for example a value is empty let's say Girl it should be Boy.Daddy

Any idea how I can achieve this using power automate?

Thanks

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @naijacoder1 ,

I have made a simple test for your reference.

concat(if(empty(items('Apply_to_each')?['ColumnA']),'',concat(items('Apply_to_each')?['ColumnA'],'.')),if(empty(items('Apply_to_each')?['ColumnB']),'',concat(items('Apply_to_each')?['ColumnB'],'.')),if(empty(items('Apply_to_each')?['ColumnC']),'',items('Apply_to_each')?['ColumnC']))
if(equals(slice(outputs('Compose'),add(length(outputs('Compose')),-1)),'.'),substring(outputs('Compose'),0,add(length(outputs('Compose')),-1)),outputs('Compose'))

Result Screenshot:

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

Hey @naijacoder1
I was able to solve your problem. Though my method is pretty long. There could be shorted methods too.
Here is the Input:
Here is the final Output:
I firstly initialized an array with your input.Then created a new array of array and after that made an empty string variable.
Then used an apply to each method, and passed the variable A in it. And then matched each item with the empty variable. If its not empty I am just appending it to the Array variable B.
After this I stored the above array in a compose and made another variable called FinalOutput.

Then I used another apply to each method and passed variable B in it.
And appended the current item in the final output string with a dot at the end.
After that I used another compose to remove the last dot from output. Actually I am getting Boy.Daddy., to remove the last dot I am using the substring method.
It formula:
substring(variables('FinalOutput'),0,sub(length(variables('FinalOutput')),1))

I hope this helps.

Was this reply helpful? Yes No
naijacoder1 11 on at

Like (0)

Report
Copy link

Link copied!

Thanks Charlie for the help.
I will give it a shot and let you know

Was this reply helpful? Yes No
naijacoder1 11 on at

Like (0)

Report
Copy link

Link copied!

Hi Charlie,
Sorry but unfortunately i'm getting this error below .

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @naijacoder1 ,

Could you please provide some screenshots of your Flow setting? That will make it much easier to assist.

The Outputs of the first Compose Action should be a string.

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
naijacoder1 11 on at

Like (0)

Report
Copy link

Link copied!

Thanks Charlie .I will do that soon

Was this reply helpful? Yes No
naijacoder1 11 on at

Like (0)

Report
Copy link

Link copied!

Please see below
I need help with Compose 2
Thanks

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @naijacoder1 ,

Based on the screenshot you provided, the first Compose Action seems to return the expected result.

The expression in the second Compose Action is to determine whether there are extra dots at the end of the string that need to be removed.

Could you please tell me what is the problem you are currently encountering? Is there any other error message.

Best Regards,

Charlie Choi

Was this reply helpful? Yes No