Unanswered

Filter a list by date

(0) Share

Report

Posted on by LouisWelker11

Hello, I have in a Sharpoint list a line with a "Date" and a line "Delivered" I only want to see entries that have the date of today and are not yet delivered.

Thanks for the help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... on at

Like (1)

Report
Filter(YourSharePointList,IsToday(Date),Delivered = 1)
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No
v-yutliu-msft on at

Like (1)

Report
Hi @LouisWelker11 ，

Could you tell me the data type of Date and Delivered?

If Date field is datetime type, you could use IsToday() to justify directly. If not, you need to transfer.

If Delivered is choice type and its choice includes "not delivered" , try this:

Filter(listname,IsToday(Date),Delivered.Value="not delivered")

If Delivered is yes or no type, not delivered represent no, try this:

Filter(listname,IsToday(Date),Delivered=0)

//0 represnt false

Best regards,

Was this reply helpful? Yes No
LouisWelker11 4 on at

Like (0)

Report

Hey @v-yutliu-msft

Thanks for youre helb but i have an error message:

Delegation warning. The "Filter" part of this formula may not work properly for large datasets.
The data source may not be able to process the formula and may return an incomplete dataset. Your application may not return correct results or behave properly if the dataset is incomplete.

Powerapp.png

Was this reply helpful? Yes No