Filter Choice field

[Anonymous]

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😥

[v-xiaochen-msft · Accepted solution]

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.

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:

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

[v-xiaochen-msft]

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.