Answered

Rename items of Combobox

(0) Share

Report

Posted on by Rennacker54

I have a Combobox that I filter a gallery by. The combobx recieves its items by all Distinct values of column A. One of the retrieved values is Blank(). I want to use this Blank() value to filter the gallery. As it is right now, it shows blank in the dropdown with no name specified to it. Is there any chance to rename this value to something like "Column A blank"?

Disclaimer: Until now I had the IsBlank value filtered out, but I now see the necessity to make it a filtering option.

Sort(
 ForAll(
 Distinct(
 Filter(DataSource.'Column A', !IsBlank('Column A')),
 'Column A'
 ),
 {Result: ThisRecord.Value}
 ),
 Result
)

Thanks for your support!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

Plz try this formula it may help you

Sort(
ForAll(
Distinct(
Filter(DataSource.'Column A', !IsBlank('Column A')),
'Column A'
),
{Result: If(IsBlank(ThisRecord.Value), "Column A blank", ThisRecord.Value)}
),
Result
)

If it's not works use If(IsBlank(ThisItem.'Column A'), "Column A blank", ThisItem.'Column A') instead of previous Result line

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @Rennacker54 ,

One method:

Sort( Distinct( AddColumns( 'Your Data', "MyList", If( IsBlank('Column A'), "# Column A - Blank", 'Column A' ) ), MyList ), Value )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Rennacker54 19 on at

Like (0)

Report
Copy link

Link copied!
Hi @Amik, how can I use this dropdown now to filter a gallery? This code adds a item to the dropdown, but when I select it my filter searches for "# Column A - Blank" instead for Items that are Blank() in Column A.
Filter(DataSource, Or(IsEmpty(DropdownA.SelectedItems), 'Column A' in DropdownA.SelectedItems))

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Rennacker54 ,

Similar logic needs to be applied to the Items property of the Gallery.

Filter( AddColumns( 'Your Data', "column_modified", If( 'Column A' = Blank(), "# Column A - Blank", 'Column A' ) ), CountRows(ComboBoxA.SelectedItems) = 0 || column_modified in ComboBoxA.SelectedItems )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No