Unanswered

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

(0) Share

Report

Posted on by AnonyMouse

I need to show items in a gallery which are not present in another gallery and am not sure how to do it.

My scenarion is like this. A user goes to a NewForm of a listX. That form has a gallery control pointing to Title column of another list, ListA.
In the NewForm of ListX,user selects a few items from ListA gallery using checkbox and then submits the form. The selected items of ListA are submitted to another list,ListB (Region column) along with the ID (RefID column) of the item that got created in ListX .
In the editform of ListX,I have galleryB which filters ListB where ListB.RefID=ListX.ID ->This shows all items user had selected in NewForm.
I would like to show items in another gallery, galleryA which are not present in galleryB.
This would be something like Filter ListA where ListA.Title not in ListB.Region . It could also be Filter ListA where ListA.Title not in galleryB.Region.
I am not able to do this. For example, Filter(ListA,Title not in galleryB.AllItems.Region ->Does not work. Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Mr-Dang-MSFT on at

Like (3)

Report
Re: Show items in a gallery which are not present in another gallery

Hi @AnonyMouse,

You're very close. It looks like just a matter of placing Not in the right spot.

Filter(ListA,Not(Title exactin galleryB.AllItems.Region))

This means, "Filter ListA to only show records where the Title of a given record does NOT appear in the Region column of galleryB."

Let me know if I understood this scenario correctly.

Was this reply helpful? Yes No
AnonyMouse 46 on at

Like (0)

Report

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

Perfect. Thanks a lot!
One more quick question. I was wondering if you know how to put the gallery control inside a datacard.
My issue is that, in the EditForm, when I insert the gallery control, it is superimposed over the editform. When I scroll in the EditForm, I would like the gallery control to come at the end of the form. But now, as soon as I insert the gallery control, it is shown on top always even if I scroll on top. I tried inserting a datacard to the eiditform and inserting a gallery in that but it made no diference however I noticed that I can insert any normal controls onto the custom card and they work fine. Could you please let me know how can I make the gallery control to come at the end of the editform scroll? Thanks

Was this reply helpful? Yes No
RM-06090351-0 36 on at

Like (0)

Report

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

Hi there,

I also have a similar need to show items from SP List A excluding those items in SP List B. Then I use a formula similar to the one from Mr. Dang as below. 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)

)

Was this reply helpful? Yes No
WarrenBelz 152,845 Most Valuable Professional on at

Like (0)

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

Hi @AnonyMouse

You have all sorts of Delegation issues there - assuming that Gallery_Completed has a field called Value, try this
With { _Data: Filter( 'HK & Macau Store information Latest', Division = Label_CityArea.Text ) }, Filter( _Data, !( StartsWith( 'Store Code', "HK7" ) ) && !( 'Store Code' exactin Gallery_Completed.AllItems.Value ) ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
RM-06090351-0 36 on at

Like (0)

Report

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

Hi WarrenBelz,

Thanks for your advice and I've tried using your suggested formula but still got a blank Gallery.

It's also strange to notice that the Gallery will show items when either one of the filters below was being used: -

- !StartsWith('Store Code',"HK7")

- Not('Store Code' exactin Gallery_Completed.AllItems.Value)

Of coz, none of the situations gave me the correct items in the Gallery.

Your further advice and suggestion is much appreciated.

Thanks
Raymond

Was this reply helpful? Yes No
WarrenBelz 152,845 Most Valuable Professional on at

Like (0)

Report

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

Hi @AnonyMouse
What is your data source type and how many records do you have ?

May be a silly question, but do you actually have records that match both as it makes no sense that they work separately, but not joined by And. As a debugging exercise, try || (Or) instead and see if it produces a combination of the two. Also try in instead of exactin and see if that makes a difference.

Was this reply helpful? Yes No