Answered

If statement with filter

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want a gallery that displays items that have been saved by a user, saved to SP list 'Pinned Applications'. If a user doesn't have any saved items then all the items from SP list 'Application Master List' should be displayed, but my formula isn't working correctly:

Gallery Items

If(CurrentO365User.Id in 'Pinned Applications'.UserID, Filter('Pinned Applications', UserID = CurrentO365User.Id), 'Application Master List')

The gallery is showing all the applications on the 'Application Master List' and not just the ones that are on the Pinned Application list.

Variables: CurrentO365User = Office365Users.MyProfile()

UserID is the primary key

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

timl 36,682 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

I would try the following to see if that returns the correct result.

If(CountIf('Pinned Applications', UserID = CurrentO365User.Id) > 0, Filter('Pinned Applications', UserID = CurrentO365User.Id), 'Application Master List' )

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

Like (0)

Report
Copy link

Link copied!

This worked! Appreciate the assistance - what an amazing community.

Was this reply helpful? Yes No
timl 36,682 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Glad this worked for you @Anonymous!

Was this reply helpful? Yes No