Filter Gallery based on another list values

[mssss]

I am trying to filter GalleryA (CDS table :plan) based on another CDS table :checklist)

table :plan

amount	month	planno
100	2019/1/1	1
200	2019/2/1	2
400	2019/2/1	3
400	2019/2/1	4

table :checklist

planno

1

3

GalleryA

On GalleryA I would like to show data of plan which is not listed in checklist.

amount	month	planno
200	2019/2/1	2
400	2019/2/1	4

Thank you!

[PowerAddict · Accepted solution]

Try this as the items property of Gallery A:

Filter(plan, !(plano in checklist.plano))

Let me know if this doesnt work.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

[mssss]

Worked!! thank you😊

[PowerAddict]

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com