Filter data based on date: Find data submitted on Sharepoint List that matches today's date

(0) Share

Report

Posted on by Dein88

Hello All,

I have an app that captures data daily and stored in a SharePoint List. How do I filter the data to today's date?

pa date.JPG

I tried the following (I don't know why it is pointing to the data card when there's a field called 'Created')

Lookup('Daily Log'.'Total Donation Received', Created_DataCard = Today())

Also tried the suggestion given by powerapps guide

Filter('Daily Log'.'Total Donation Received', Created_DataCard >= Today(),
Created_DataCard < DateAdd(Today(),1,Days)

But got an error saying "Invalid Argument Type". Expecting one of the following: Number, Date, Time, DateTime

How do I fix this error? Tried other functions to change the Created_DataCard argument type e.g. Text, Date, DateValue etc. but have yet to solve this issue.

Categories:

Building Power Apps

All responses (5)

Answers (2)

Sort by

Verified answer

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Filter(tableName, dateColumnName >= Today())

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Dein88 , just following up. Did this work?

If so please accept the above as a solution to close this support thread.
Verified answer

Dein88 41 on at

Like
a
(2)

Report
Copy link

Link copied!
Thanks Phipps for your help. Tried your solution but got an error instead.

I played around and I realised I made some minor mistake there. Managed to get the results via the following:

LookUp('Daily Log',Date >= Today(), ThisRecord.'Total Donation Received')

I did some extra work to basically let user knows if there is no data matching the condition/logical test, then print "NA". I think I did this correctly. Please let me know if there's anything wrong with it

If(IsEmpty(Filter('Daily Log', Date >= Today(),ThisRecord.'Total Donation Received')),LookUp('Daily Log', Date >= Today(),ThisRecord.'Total Donation Received'),"NA")
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Dein88 so all is working now?
Dein88 41 on at

Like
a
(1)

Report
Copy link

Link copied!

Yup. Oh @phipps0218 your solution actually works. I just realised that the 'Filter' function can only be used with a Dropdown.

If I were to use a Label to show the value, then I would need to use the 'Lookup' function instead.
So kudos to you.