web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter with distinct

Power Apps

Answered

Filter with distinct

(0) Share

Report

Report

Posted on by powerulmo

70

A list is provided with the following formality:

SortByColumns(Distinct(List1 ,Einrichtung),"Value", SortOrder.Ascending)

Now I would like to expand this formula by not displaying a value (Zentrale) from List1. Can anyone help me how to do this without getting a delegation warning.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @powerulmo ,

Do you mean that remove "Zentrale" from result?
Please try this:
SortByColumns(Filter(Distinct(List1,Einrichtung),Not(Value="Zentrale")),"Value",SortOrder.Ascending)

Best regards,
Rimmon
powerulmo 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Very nice and so simple. Thank you.

Join the conversation