web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Choices with st...

Power Apps

Answered

Filter Choices with startswith ?

(1) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like (4)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@v-bofeng-msft
@VijayTailor

Thank you ! worked😉

Was this reply helpful? Yes No

Join the conversation