Concat Dropdown items with if condition

(0) Share

Report

Posted on by christian12

204

Hi Guys,

In my dropdown list I'm showing two items from my collection with the below code. This works fine.

SortByColumns( AddColumns(Types, "Mod&Des", Concatenate(MType, " - ", Description)), "Mod&Des")

However, when I'm missing either a Mtype or Description its still adding in the "-" as this is a string and will be included for every line of my collection.

Is there a way to add in an if formula when say the Description or Type is empty not to add in the "-", and only add it in when both values are there.

Any help is greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@christian12

With({ccat: If(IsBlank(MType),Description, IsBlank(Description), MType, Concatenate(MType, " - ", Description) )}, SortByColumns(AddColumns(Types, "Mod&Des", ccat, "Mod&Des", Ascending) )

Was this reply helpful? Yes No
christian12 204 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp

Thanks although I'm getting an if error.

FYI the Mtype & Description are two separate columns in my Types collection.
Unsure if it is the IsBlank part of the code as it is not pointing to a collection/column which might be causing the error.

Thanks again

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@christian12

If they are choice columns you need to append .Value to the column names

Was this reply helpful? Yes No
christian12 204 on at

Like (0)

Report
Copy link

Link copied!

No there not choice names

Collection name: Type
Mtype Description
22
33 Blue
Black
44 Pink

End Result will look like this. (with also the sort functionality)
Mtype Description Mod&Des
22 22
33 Blue 33 - Blue
Black Black
44 Pink 44 - Pink

The code for some reason doesnt work. I get the error column name conflict for 'Mod&Des'

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @christian12 ,

Please try:
SortByColumns(AddColumns(FH,"Mod&Des",If(IsBlank(Mtype),Description,IsBlank(Description),Mtype,Concatenate(Mtype,"-",Description))),"Mod&Des")

Best Regards,
Dezhi

Was this reply helpful? Yes No