web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Concatenate, but skip ...

Power Apps

Answered

Concatenate, but skip over blank value

(0) Share

Report

Report

Posted on by jessicadduffey

Hello -

I'm looking to concatenate the values from a selected record from 5 columns:

Address

Address2

City

State

Zip

So that when the formula is executed, I have something like this: Address, Address2, City, State Zip

Here is the formula that I've written

Concatenate(varSelectedLoc.Address,", ",varSelectedLoc.Address2,", ",varSelectedLoc.City,", ",varSelectedLoc.State," ",varSelectedLoc.Zip)

Address2 often has a blank value in my table, but not in every situation. Is there any way that this formula can be amended to skip over the blank value so that I still come up with something like this: Address, City, State Zip?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @jessicadduffey,

If only Address2 may sometimes be empty, you could use the following approach:

$"{varSelectedLoc.Address}, {If(!IsBlank(varSelectedLoc.Address2), varSelectedLoc.Address2 & ", ")}{varSelectedLoc.City}, {varSelectedLoc.State}, {varSelectedLoc.Zip}"

In this case we use string interpolation to improve readability and use an If statement to only display Address2 when it has a value. (I have also added a comma between State and Zip.)

If we expect multiple fields to possibly be empty, we may need a more dynamic approach.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No

Join the conversation