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)
Solved! Go to Solution.
Hi @mssss :
Please try this formula:
Filter(Choices(YourTable.ChoiceColumn),"2" in Text(Value))
Or
Filter(Choices(YourTable.ChoiceColumn),StartsWith(Text(Value),"2"))
Best Regards,
Bof
HI @mssss ,
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
Hi @mssss :
Please try this formula:
Filter(Choices(YourTable.ChoiceColumn),"2" in Text(Value))
Or
Filter(Choices(YourTable.ChoiceColumn),StartsWith(Text(Value),"2"))
Best Regards,
Bof
HI @mssss ,
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
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
208 | |
71 | |
51 | |
49 | |
20 |
User | Count |
---|---|
264 | |
122 | |
85 | |
80 | |
68 |