web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Show items in a galler...
Power Apps
Unanswered

Show items in a gallery which are not present in another gallery

(0) ShareShare
ReportReport
Posted on by 36
Re: Show items in a gallery which are not present in another gallery

Hi there, 

I have a need to show items from SP List A excluding those items presented in SP List B. Then I use a formula as below in order to Filter List A to only show records where the "Store Code" of a given record does NOT appear in the Gallery_Completed.

It however gave me a blank page but gave me all items if I omitted the "Not".

I've tried many other options but still cannot figure it out.

Your support is much appreciated.

Thanks
Raymond

 

    Filter(
        'HK & Macau Store information Latest',
        Division = Label_CityArea.Text
        &&
        !StartsWith('Store Code',"HK7")
        &&
        Not('Store Code' exactin Gallery_Completed.AllItems.Value)
    )
Power App Issue 1.jpg
Power App Issue 1_2.jpg.png
Categories:
I have the same question (0)
  • timl Profile Picture
    36,713 Super User 2026 Season 1 on at
    Hi Raymond,
     
    The cause of this could be because exactin isn't delegable. 
     
    How  many records are there in your 'HK & Macau Store information Latest' list?
  • WarrenBelz Profile Picture
    154,447 Most Valuable Professional on at
     @RM-06090351-0​​​​​​​
    This post seems to be the same question - I assume that is also you  ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard