Answered

Filter gallery by distinct and not isblank

(0) Share

Report

Posted on by Matt383

407

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.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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
Matt383 407 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks WarrenBelz, no errors but gallery is blank. i am only trying to display one column (text field) That contains entries
Matt383 407 on at

Like
a
(0)

Report
Copy link

Link copied!

I see what you mean now, i needed to change the field in the gallery to ThisItem.Value. Thanks WarrenBelz