I have an app I am working on that is used for booking desks.
There is a gallery that should filter the bookings shown in the gallery based on user email address AND where the 'Check Out From Number' (which is a date converted to a number) is >= Todays date converted to a number value.
I have included snippets of the gallery filter statement and the SharePoint list.
For some reason it shows booking dates that have past today's date, cant figure out why. The email address part of the filter is working as expected, it's the number part that is not. Please help?
Please see attachments.
Can you try using the DateDiff function on the original Checkoutfrom date instead of converting and just filter on everything that has a positive nr of days?
DateDiff( CheckoutFrom, Today()) > 0
You might need to use Date Value to align the formats, but this should work
Hope this helps - Good Luck! ☘
'Reserved By'.Email = currentUser.Email && 'Check Out From Number' >= Value(
Hi @snipesnab I made an excel file with your data and maybe found a solution for your problem.
What if you use you Column named: Check Out From (as Date) and compare that data with today's date. Does it works for you?
Because if so, you can just use the following formula and you Gallery might work just fine:
&& DateValue('Check Out From') >= DateValue(Today())
Hope it helps.
I think now the problem is the && (and) part of the formula.
Try instead of using &&, just put a , (comma) between the two conditions, power apps will understand that inside a filter function.
Plus, see the video below for more understanding about the filter function and delegation problems
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.