Filter Choices with startswith ?

[Anonymous]

Hello,

Is it possible to filter Choices using "startswith"?? all data is in CDS(Dataverse)

I have a combo box selection with number like following (multi selection).

100_categoryA

200_categoryB

300_categoryC

When I chose "200_categoryB" I would like to show item start with 200-299 in next combo box.

201_item1

202_item2

I've tried  arranging following but did not work how I would like to do.

Filter(Choices(products),"2" in Value)

[v-bofeng-msft · Accepted solution]

Hi @Anonymous :

Please try this formula:

Filter(Choices(YourTable.ChoiceColumn),"2" in Text(Value))

Or

Filter(Choices(YourTable.ChoiceColumn),StartsWith(Text(Value),"2"))

Best Regards,

Bof

[VijayTailor · Accepted solution]

HI @Anonymous ,

Please Find the Solution for your Problem below - 
See the Data Structure-

So First ComboBoxCode Like below - 

CateSource //Source

Second Combo Box Filter Code.

Filter(ItemSource,StartsWith(CateName,First(Split(ComboBox1.Selected.CateName,"_").Result).Result))

Please Find the Demo for the Same.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

[Anonymous]

@v-bofeng-msft 

@VijayTailor 

Thank you ! worked😉