cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mssss
Helper V
Helper V

Filter Choices with startswith ?

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)

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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

 

View solution in original post

VijayTailor
Resident Rockstar
Resident Rockstar

HI @mssss ,

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

VijayTailor_0-1613546405086.png

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.
Sorting_FilteringComboCascading.gif

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





View solution in original post

3 REPLIES 3
v-bofeng-msft
Community Support
Community Support

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

 

VijayTailor
Resident Rockstar
Resident Rockstar

HI @mssss ,

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

VijayTailor_0-1613546405086.png

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.
Sorting_FilteringComboCascading.gif

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





@v-bofeng-msft 

@VijayTailor 

Thank you ! worked😉

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,598)