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

 

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

@v-bofeng-msft 

@VijayTailor 

Thank you ! worked😉

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,500)