cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snipesnab
Helper II
Helper II

Filter SharePoint list in PowerApps Gallery - something is not work as expected, can't figure it out - Please help

Hi All,

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.

 

 

7 REPLIES 7
CNT
Super User
Super User

@snipesnab Can you post the formula as a text in the chat.

AmDev
Super User
Super User

Hi @snipesnab 

 

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! ☘

FirstN(
SortByColumns(
Filter(
'Desk Reservations',
'Reserved By'.Email = currentUser.Email && 'Check Out From Number' >= Value(
Text(
Today(),
"yyyymmddhmm"
)
)
),
"CheckOutFromNumber",
Ascending
),
2
)

Ternioo
New Member

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.

Thank You

Thanks, seems to work but does it matter about the warning - see image below:

snipesnab_0-1638291257049.png

 

Thanks, your solution seems to work however I also get the following delegation warning:

 

snipesnab_2-1638291574622.png

 

 

Ternioo
New Member

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

Learn to use the PowerApps Filter function - YouTube

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,863)