Hi,
I have 2 galleries which both have DATE and PONO fields.
What I would like to do is create a third gallery which shows all the records in Gallery2 which do not match DATE and PONO from Gallery1.
e.g. if a record with date 15/02/2022 with PONO 123 exists in Gallery2, but NOT in Gallery1, then show in Gallery3.
The PONO may exist in multiple DATE, so I need to check against both DATE and PONO.
I have the following which works on checking the PONO only, but how can I add the DATE check.
Filter(Gallery2.AllItems,Not( PONO exactin Gallery1.AllItems.PONO))
Your assistance is greatly appreciated.