cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter Choice field

Hello,

 

I am trying to filter Dataverse  Choice(multi selection). (using Dataverse, over 2000 data)

 

I have tried like this but not working.

  • Filter(tablename, "a_" in choice column name)
  • Filter(tablename, "a_" in choice column name.Value)
  • Filter(tablename, "b" in Choices('column name'))

Should I use Addcolum? 

Sorry for asking same kind of questions😥

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Anonymous ,

 

Firstly, If your data exceeds 2000, you cannot avoid delegation issue.

Secondly, I provide you with solutions within 2000 data.

Although it will not report an error for more than 2000 data, it will return incomplete results.(Because of delegation)

 

Please refer to the steps below:

1\ This is my table .'Test' is a 'Choices' column.

v-xiaochen-msft_0-1614048659247.png

 

2\ Add a button control and set its Items property to:

ClearCollect(Test2,your table name)

// This step cannot be omitted

 

3\ Add a combo box control and set its Items property to:

Choices(your table name.Test)

 

4\ Add a gallery control and set its Items property to:

Ungroup(ForAll(ComboBox1.SelectedItems.Value,Filter(Test2,Value in Test)),"Value")

 

5\ The result is as follows:

AAA.gif

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @Anonymous ,

 

Firstly, If your data exceeds 2000, you cannot avoid delegation issue.

Secondly, I provide you with solutions within 2000 data.

Although it will not report an error for more than 2000 data, it will return incomplete results.(Because of delegation)

 

Please refer to the steps below:

1\ This is my table .'Test' is a 'Choices' column.

v-xiaochen-msft_0-1614048659247.png

 

2\ Add a button control and set its Items property to:

ClearCollect(Test2,your table name)

// This step cannot be omitted

 

3\ Add a combo box control and set its Items property to:

Choices(your table name.Test)

 

4\ Add a gallery control and set its Items property to:

Ungroup(ForAll(ComboBox1.SelectedItems.Value,Filter(Test2,Value in Test)),"Value")

 

5\ The result is as follows:

AAA.gif

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

v-xiaochen-msft
Community Support
Community Support

Hi @Anonymous ,

 

Is this solution useful to you?

Could you elaborate on the problem you encountered?

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,374)