I am making a powerapp for deskreservations at our office. I hade 2 data source tables, "Desks" and "Desk Reservations". They are both SP Lists. I have a gallery where i would like to show all desks availible for the selected date. The filter im trying to create is something like this:
Show "Desks" item IF Desks.Title IS NOT "Desk Reservations".DeskName AND selectedDate IS NOT "Desk Reservations".Date
So in other words I would like to show all "desks" items that doesnt match an item in "Desk Reservations" on the selected date..
Thanks
I have tried a lot of different filters bu can't seem to find something that works...