Count the number of records(Items) has recorded between selected date.

(0) Share

Report

Posted on by ShaikSayyad

111

Hi Mates,

I want to count the number of items in between selected dates from a SharePoint list. I have Created On date and time field standard date and time format.

I have tried with datepickers with below formula

CountIf('EUTSTSTS','Created On' >= DatePicker2_1.SelectedDate && 'Created On' <= DatePicker3_1.SelectedDate)

but it was not showing true count. please refer below screen for your idea.

Please help me to resolve it. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Merlijn 128 on at

Like
a
(1)

Report
Copy link

Link copied!
You can try to use the Count around a filtered source. So you filter your datasource on the start-end date/time, and you count these rows.

CountRows(FilteredSource)
Set this code in the Text-property of a label, and you see the number of rows.

Was this reply helpful? Yes No
ShaikSayyad 111 on at

Like
a
(0)

Report
Copy link

Link copied!
I had tried with below formula
CountRows(Filter('EUSTSTS','Created On'>= DatePicker2_1.SelectedDate && 'Created On' < DatePicker3_1.SelectedDate))
But same thing happened again. It was showing wrong count only

Was this reply helpful? Yes No
Merlijn 128 on at

Like
a
(0)

Report
Copy link

Link copied!

You can also set the formula in a Datatable, this way you see your filtered source. This way you can analyze, and edit your formula until you have the expected result.

If you need more help, please share some screenshots of the issue..

Was this reply helpful? Yes No
v-yuxima-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ShaikSayyad

Could you please check whether your PowerApp and the SP has the same time zone?

If not,please set them to same and then test again.

More information:

function-dateadd-datediff

Best Regards.

Yumia

Was this reply helpful? Yes No
Milansinh Raj 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ShaikSayyad ,

Actually whatever condition you are using with ">=" or "<=" or "<" or ">" - this are delegable functions, using this data can be vary, it wont show you always the correct result.
You could see there, the function you have written there should be blue line and it will show you message of delegation.
Below is link for delegable function and more details:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

For getting exact count of records you need to find a way which is not using any of the delegable functions/operators.

Thanks,
Milansinh Raj

Was this reply helpful? Yes No
ShaikSayyad 111 on at

Like
a
(0)

Report
Copy link

Link copied!

See I'm not getting any delegable errors in my formula,please have a look into the below screen you would get what was the my issue.App screen

SharePoint List
Actually the true count was 74 in between selected dates but it was showing 54 only.
for your information my SP list has date and time format.

Was this reply helpful? Yes No
Milansinh Raj 149 on at

Like
a
(0)

Report
Copy link

Link copied!
CountRows(Filter('EUSTSTS',DateValue(Text('Created On'))>= DatePicker2_1.SelectedDate && DateValue(Text('Created On')) < DatePicker3_1.SelectedDate))
As you said SP list have Date Time format, we have converted 'Created on' field to Date and then compared.
let me know after trying this formula.

CountRows(Filter('EUSTSTS',DateValue(Text('Created On'))>= DatePicker2_1.SelectedDate && DateValue(Text('Created On')) < DatePicker3_1.SelectedDate))

Was this reply helpful? Yes No
ShaikSayyad 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Not woring, I got the same result 54 items only.

Was this reply helpful? Yes No
Milansinh Raj 149 on at

Like
a
(0)

Report
Copy link

Link copied!

can you display value on Text label of Selected dates ? So I can see what its taking from Date Control ?

Was this reply helpful? Yes No
ShaikSayyad 111 on at

Like
a
(0)

Report
Copy link

Link copied!

you can see the value of the label that is 54 (Selected label- showing value after selected dates only) in the above provided picture.

Was this reply helpful? Yes No