Unanswered

Concate values that are not blank

(0) Share

Report

Posted on by Community Power Pla...

I have at Flow that gets Planner tasks, and where I need to get the label values as well. I have made a variable to each label colour, and that parts works just fine. When I get the label, I replace the True value with a department name, and that part also works fine. The question I have is when I try to concat the labels. I want to avoid blank values when I concat the values. Is this possible?

This is a part of my flow

And this is how i have build up my concat

So I want to avoid concatting blank values in my "ComposeAll". Can this be done?

/Frank

Denmark

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

ccc333ab 1,144 on at

Like (0)

Report

Confused a bit on your question, so I may answer incorrectly.

I am assuming some rows of your excel file may produce blanks in either of those two fields. And with whatever happens after the ComposeAll steps, you don't want blanks to be continuing on. If that is the case, can you just add in a Condition to check for blank, and not do anything if it is blank...something like:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

HI @ccc333ab and thx for your reply. I might have been to bad to explain my needs. I have 16 departments that each have their own label in Planner. I am translating the colour value to a department name. Each value is concatenaited in a single field, so we can track wich department is involved in a task. If I concatenate several depatrments I am afraid it will look awfull if blank values are a part of the string. Then it will look like "DepA,DepB, ,DepD, ,DepF" and so on. So it is a question, if it it possible to remove the blank values in the string.

/Frank

Was this reply helpful? Yes No
ccc333ab 1,144 on at

Like (1)

Report
Many different ways you can achieve this, but with your current flow, the easiest would be just to continue using Replace expression, but instead replace the ', ,' with ', '. So for example:
replace(variables('strDepartments'),', ,', ', ')
Note: In your screenshot, you would replace variables('strDepartments') with your final OUTPUT from the ComposeAll action.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi again @ccc333ab that looks as an solution I can use. I will test it one of the following dayes and report back 😊

/Frank

Was this reply helpful? Yes No