web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter For Gallery = N...

Power Apps

Answered

Filter For Gallery = Not User

(0) Share

Report

Report

Posted on by Edd-Keogh

297

Good afternoon all,

I am currently trying to create an approval app and don't want people to be able to approve their own. So I have setup the gallery to populate the edit form all fine but I want to filter the gallery to not include the current user's submissions. So far I have:

Filter('My List','Created by'=User().FullName)

This brings back everything created by the user, how can I get it exclude everything the user has created?

Thanks for any help out there!

Edd

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Edd-Keogh ,

Right now, your formula is returning every record created by the user. If you want to get all record NOT created by the user, you can invert a boolean with "Not()".

Filter( 'My List', Not('Created by'=User().FullName) )

Was this reply helpful? Yes No
Edd-Keogh 297 on at

Like
a
(0)

Report
Copy link

Link copied!

Spot on thank you!

Was this reply helpful? Yes No

Join the conversation