Power Platform Community Forum Thread Details

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