Vertical Gallery Filter

[normmsnpoweruse]

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
    )
)

[WarrenBelz]

Hi @normmsnpoweruse ,

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

[normmsnpoweruse]

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

[WarrenBelz]

@normmsnpoweruse ,

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

[normmsnpoweruse]

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

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

[WarrenBelz]

@normmsnpoweruse ,

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)

[normmsnpoweruse]

Got it

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

[normmsnpoweruse]

Finally, got it.

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