Announcements
[Power Apps Form]Hello! Is there any way to display choices in dropdown control that starts with specified values/character?For example, the choices in my dropdown are:20210000012021000002...202200000120220000022022000003..and so on.In my dropdown control, I only want those that starts with 2022 to appear in the choices.Is there any way to combine Choices(), filter() and starts with() in the formula bar? Or how should it be achieved without deleting the 2021 in the data source?Thank you!
Hi @LaraDanicaLim ,
You did not post your current Items of the drop-down, but assuming it is a Choice/Lookup column, you could do this
Filter( Choices(ListName.FieldName), StartsWith( Value, "2022" ) )
If it is a list name and field name, replace the second line with your current Items.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Hi, @WarrenBelz . Say for example I have these as my choices. And I only want to display those that starts with 100. The column name is Title. I have tried the formula but it returns an error.
In the Advanced Property is this:
@LaraDanicaLim ,
The Items would be
Filter( SPListName, StartsWith( Title, "100" ) ).Title
@WarrenBelz , that worked! Great! Thanks a lot! Happy New Year! :))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 354 Super User 2026 Season 2
M Bilal Khan 320
Mohsin Ali 246
