Unanswered

Vertical Gallery Filter

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

How would you edit this to show a power app gallery where DepartmentStatus Sharepoint listcolumn is "Active"

ForAll(
 Distinct(
 'Table Service',
 Title
 ),
 LookUp(
 'Table Service',
 Title = Result
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

The code you posted goes around in a bit of a circle - you only need the Distinct Value of Title - to Filter

Distinct( Filter( 'Table Service', DepartmentStatus.Value = "Active" ), Title ).Result

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Not working, I am getting an error incompatible types: Table, Text

Was this reply helpful? Yes No
WarrenBelz 155,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Anonymous ,

Depends where you are using that - it will produce a Table of the distinct values and would normally be used as the Items of a drop-down/combo box.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
How would you change this to sort the results in ascending order?

ForAll( Distinct( 'Table Service', Title ), LookUp( 'Table Service', Title = Result ) )

Was this reply helpful? Yes No
WarrenBelz 155,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

You just need to wrap that in a Sort on the field in the table you want to sort on (you did not specify the field)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Got it
ForAll( Distinct(Sort( 'Table Service', Title), Ascending ), LookUp( 'Table Service', Title = Result ) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Finally, got it.

ForAll(Sort( Distinct( 'Table Service', Title), Result).Result , LookUp( 'Table Service', Title = Result ) )

Was this reply helpful? Yes No