Answered

filter and count data by date of the day of a sharepoint column Function (Today) if possible

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

hello, How can I filter data from a sahrepoint list by date?

I need to count and show in several label, how many are pending and how many are ending based on a sharepoint column called (status)

show labels by date, if possible with the "today ()" function

It is similar to the template offered by powerapps called (Service Desk)

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

You can count the number of rows for each status by putting this into a label. My response assumes Status is a Choices data type in SharePoint.

CountRows(Filter(your_datasource_name, Status.Value = "Approved", Created = Today()))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thanks, at the time the date didn't work for me,
All data is counted and not by the current day

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

I don't understand your comment "all data is counted and not by the current day."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
hello, sorry, this is my app,

the gallery shows all the data entered, at the moment (4 records)

I just want to show the data of the day, for example: the 2 records of day 26

I have a problem with this formula in the part Created = Today()
CountRows(Filter(your_datasource_name, Status.Value = "Approved", Created = Today()))
it makes me wrong

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

If you try to FILTER a date in SharePoint you will run into delegation issues. You must create 3 new Number columns in SharePoint createdYear, createdMonth, createdDay. For new every record that gets created you must populate these values. (e.g. 2/26/2019 becomes createdYear: 2019, createdMonth: 2, createdDay: 26).

Put this code in the OnVisible property

Set( currentDate, { Year: Year(Today()), Month: Month(Today()), Day: Day(Today()) } )

Then you use this code to count the rows

CountRows( Filter( your_datasource_name, Status.Value = "Approved", createdYear = currentDate.Year, createdMonth = currentDate.Month, createdDay = currentDate.Day ) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No