Hello
I have a filter gallery on my form and I am looking to set one of the values as the default.
For example:
Calcelled
Late
New <- I want to set New as the default
Closed
Items code uses a collection and works perfectly
Gallery > Items > Sort(Distinct(EmpCollection, 'Employee Status'.Value),Result,Ascending)
Default code does not work
Gallery > Default > LookUp(EmpCollection, 'Employee Status'.Value="New")
Error message - Invalid Formula. Expected a value compatible with 'Items'
Any suggestions?
Thanks,
Yoshi
I fixed it.
Based on the error message "Invalid Formula. Expected a value compatible with 'Items'", the formula is looking for a record, so I simply wrapped my Items code in a Lookup.
Gallery default code now looks like this.
LookUp(Sort(Distinct(EmpCollection, 'Employee Status'.Value),Result,Ascending), Result="New")
Thanks
Yoshi
Thanks @Ramole I tried that link and a few others before posting to this forum. Unfortunately, it doesn't work.
This post will explain how to do it
How to set default item in a Gallery
Gallery control in 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.