Hi, I have my gallery filtered to show only entries that have content but also need to show only distinct values. This is what i currently have. I thought just putting the Distinct( at the front would work but no joy
Filter(Parts_Request, Not(IsBlank(PartsOrderNumber)))
Any assistance would be much appreciated.
I see what you mean now, i needed to change the field in the gallery to ThisItem.Value. Thanks WarrenBelz
Thanks WarrenBelz, no errors but gallery is blank. i am only trying to display one column (text field) That contains entries
Hi @Matt383 ,
This should do it, but note that Distinct only returns one column called Value
Distinct(
Filter(
Parts_Request,
!IsBlank(PartsOrderNumber)
),
PartsOrderNumber
)
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