Answered

Concat and add to values but not the first and last value

(0) Share

Report

Posted on by JimmyW

2,567

I'm trying to put all values from multiple columns together but filter out any empty columns, I have this working but I'm also adding

" " for html formatting, now I don't want to add the if there is only one item that is not blank. And I don't want to add to the last item if there are multiple.

Concat(Filter([DataCardValue35.Text, DataCardValue36.Text, , DataCardValue37.Text, , DataCardValue38.Text], Value <> ""), Value&"<br>")

The above is giving me the format I want and filters out empty DataCards but I don't want to add if there is only one item with a value and the rest are empty and I would also like to remove the last or else I end up with break lines I don't need.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@JimmyWork

Please consider changing your Formula to the following:

With({_d: Concat( Filter([DataCardValue35.Text, DataCardValue36.Text, DataCardValue37.Text, DataCardValue38.Text], !IsBlank(Value) ), Value & " " ) }, Left(_d, Len(_d) - Len(" ")) )

I hope this is helpful for you.
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Thank you so much

This is working perfectly, now I just need to understand how the code works.
I could you please short explain how this works, I can understand the functions Left, Len and With but you added _d: not sure how this all works together
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@JimmyWork

_d is just a variable name. When you use a With function, what is defined in it is accessible for the entire Formula that is contained within the With.

If you have a single value or need to reference the With variable, then you just specify a variable name. Being a little lazy, I just called it _d - short for _data.

So the bulk of the formula - the Concat - is done and assigned to a With variable called _d. This is just to avoid typing the formula multiple times to get the same results.
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Thank you for taking your time and answering me, always good to learn something new 😁