Dataverse Choices for dropdown have all option that shown all the choices.

(2) Share

Report

Posted on by CU24121005-0

Hi,

I trying to do a dataverse choices filter and patch.

I wanted to do a filter of status using dropdown but inside dropdown I have option of All. I saw a very long time ago video about this but try to do it did not work.

PowerApps - Add an "All" to your Dropdown Lists - Dynamically! I need to do something like this guy did.

Anyone have any idea please help.

Thanks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@CU24121005-0, There is a similar post long back check the solution worked for you as well.

https://community.powerplatform.com/forums/thread/details/?threadid=da39496a-969a-ef11-8a69-7c1e5216d582

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
CU24121005-0 19 on at

Like
a
(1)

Report
Copy link

Link copied!

The formula not working for me I try and have Error for the Text, Error shown: Expected text or number. We expect text or a number at this point in the formula.

I have found a work around way to add all inside my dropdown the code is:

ClearCollect(Status, {Value: "All Status"});

Collect(Status, ForAll(Choices(EmailstatusRecord.'Email Status'),{Value: Text(Value)}));

I try Filter(Dropdown.Selected.Value = "All Status" || 'Email Status'.Value = Dropdown.Selected.Value)

Shown Error: Incompatible types for comparison. These types can't be compared: Table, Text.

If I wrap it Text on my choice it gave error: Expected text or number. We expect text or a number at this point in the formula.

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@CU24121005-0,

Open your Dataverse table column Email Status and check Allow multiple selections ?

Was this reply helpful? Yes No
CU24121005-0 19 on at

Like
a
(0)

Report
Copy link

Link copied!

I have allow multiple selection in my choices column.

Was this reply helpful? Yes No
CU24121005-0 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone know how to filter the gallery data for choices column? Cause I still getting error from the filter.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@CU24121005-0,

I will add another suggestion here - create another Choices table (...more > Choices) with all the entries you need (I will call it Email_Status here), then the Items of the Combo Box would be
Choices(Email_Status)

then your filter should work (with your Table Name) - assuming multiple selections here)
Filter( YourTableName, Dropdown.Selected.Value = "All Status" || 'Email Status'.Value in Dropdown.SelectedItems )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
CU24121005-0 19 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

I need it to be dropdown and needed inside to have an "all" option choices, is it still possible to do it nowadays? Cause I cannot find anyone did it only the guy in the video (Randy Hayes) and few others did but the code does not work anymore as the video is 5 years ago.

Try the formulate you gave (

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CU24121005-0,

The code works fine with SharePoint, but not with Dataverse, which is why I suggested simply creating another Choices (option set) table in Dataverse with all the choices you want and then using that in the drop down.

The other option is to simply put the Items in manually
[ "All Status", "Your Status 1", "Your Status 2", . . . . . ]

and make 'Email Status' a Text field.

Filter( YourTableName, Dropdown.Selected.Value = "All Status" || 'Email Status' in Dropdown.SelectedItems )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU24121005-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No