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

I have the same question (0)

All responses (6)

Answers (1)

v-mengmli-msft on at

Like (0)

Report

Hi @Joseq2 ,

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

Best regards,
Rimmon

Was this reply helpful? Yes No
Verified answer

WillPage 2,307 Super User 2025 Season 2 on at

Like (1)

Report

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));

Was this reply helpful? Yes No
Joseq2 38 on at

Like (0)

Report

yes, it is the default column created that comes in sharepoint and is date and time

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

Like (0)

Report
Hi @Joseq2 ,

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

Best regards,
Rimmon

Was this reply helpful? Yes No
Joseq2 38 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Joseq2 38 on at

Like (0)

Report

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));

Was this reply helpful? Yes No