web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Count rows in SharePoi...

Power Apps

Answered

Count rows in SharePoint list and Distinct Title, and selected dates

(0) Share

Report

Report

Posted on by Greg68

138

Hello everyone,

In a SharePoint list, I'm counting rows with a value using Distinct and dates and I'm getting wrong numbers, I'm not sure how I can filter them out by date range in the selected dates!

Can you please help?

With({StartDate:DateFrom_1.SelectedDate,EndDate:DateTo_1.SelectedDate},
CountRows(Distinct(Filter('Attendance',Presence="P" && Program=Label_ONE.Text),Title)))

Thanks a lot

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Greg68

With({StartDate:DateFrom_1.SelectedDate, EndDate: DateTo_1.SelectedDate}, CountRows( Distinct( Filter('Attendance', Presence="P" , Program=Label_ONE.Text), YourDateColumn>=StartDate, YourDateColumn<=EndDate ), Title ) ) )

It is not clear to me if you have a single date column in your list or if you have a startdate column and an enddate column. If the latter is the case, substitute your startdate column in the first YourDateColumn and your enddate column in the second YourDateColumn in the formula.
Greg68 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Drrickryp It worked perfectly.

Join the conversation