[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:
2021000001
2021000002
.
.
.
2022000001
2022000002
2022000003
.
.
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!
The Items would be
Filter(
SPListName,
StartsWith(
Title,
"100"
)
).Title
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:
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.