I have a simple collection that is populated from a database view.
ClearCollect(PendingEquipmentCollection, '[dbo].[vwPendingEquipment]')
I have two gallerys. One gallery the user selects and ID from, which then filters the above collection. My issue is, the filter code is not working against the collection, but it works against the view.
This works:
Filter('[dbo].[vwPendingEquipment]', RequestID = TreeGallery_DetailsScreen.Selected.Entity)This does not:
Filter(PendingEquipmentCollection, RequestID = TreeGallery_DetailsScreen.Selected.Entity)
What's even more perplexing, if I hard code the value of the entity into the collection filter, it still doesn't work, for example:
Filter(PendingEquipmentCollection, RequestID = "123456")
But if I change the column I'm filtering on, it works, for example:
Filter(PendingEquipmentCollection, Job = " 1202.")
Any thoughts on why this is not working when it works just fine directly against the view?
Filter(PendingEquipmentCollection, RequestID = TreeGallery_DetailsScreen.Selected.Entity)
For those who are more visual, here is a screenshot to validate the working vs non-working against the same id:
Working:
Not working:
