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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
164 | |
94 | |
64 | |
60 | |
60 |
User | Count |
---|---|
243 | |
163 | |
94 | |
84 | |
82 |