Answered

Filter sharepoint list by column created only the date and must be delegatable

(0) Share

Report

Posted on by Joseq2

I have a collection whose origin is a sharepoint list to which data is entered daily. I want the source to be filtered so that it takes the values entered only for today.

I have tried:

Filter(InventaryRegister;Creado=Now());

But it doesn't work for me, I think it is also evaluating the hours of the NOW() function but I want it to only evaluate the date.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Joseq2 ,

Is "Creado" column a date type?
I hope you can provide more details.

Best regards,
Rimmon
Verified answer

WillPage 2,339 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

To get the current day without the time, then Today() is the function to use. However, if your SharePoint list column is date and time then the equals operator will never return any results. You need to either make the column date only in SharePoint or do your filter query like Filter(InventaryRegister;Creado>Today() && Creado < DateAdd(Today(),1,Day));
Joseq2 38 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, it is the default column created that comes in sharepoint and is date and time
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Joseq2 ,

Are you using the "Created" column that come with SharePoint?
Please try this:
Filter(InventaryRegister,IsToday(Created))

Best regards,
Rimmon
Joseq2 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the answer, only that the formula points out delegation problems which would affect the application later because I plan to continue entering more data.
Joseq2 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Gracias por la respuesta esta fue la solución, en la formula dateadd no funcionaba cuando puse en las unidades day por lo cual lo reemplace por TimeUnit.Days.
Filter(InventaryRegister;Creado>Today()&&Creado<DateAdd(Today();1;TimeUnit.Days));