Answered

Count the number of records in the sharepoint list within a day

(0) Share

Report

Posted on by sbgoh

284

Hi, is there a way to count the number of records in the sharepoint list within a day?
I have 100 items in the list but I tried this filter query in sharepoint "Get Items", it keeps return me 99 items.
Any advise? Thanks!
issueDate ge '@{formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')}' and issueDate le '@{formatDateTime(utcNow(), 'yyyy-MM-ddT23:59:59Z')}'

I have the same question (0)

All responses (12)

Answers (1)

CFernandes 8,396 Most Valuable Professional on at

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

@sbgoh In the Get items, you can add a Filter Query.

Created ge '2020-08-28'

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

Hi @CFernandes, it only return 1 record for me.

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on at

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

@sbgoh For testing purpose, try using another another date.

Another option would be to use the REST API.

/_api/web/lists/getbytitle('FirstNameLastName')/items?$select=ID,Created&$filter=Created%20ge%20%272020-08-28%27

Try to do some Trial Error at your end.

I hope you it helps you investigate further.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

There is timezone issue but I am unable to solve it. My issueDate is a date time field.

Was this reply helpful? Yes No
CFernandes 8,396 Most Valuable Professional on at

Like (0)

Report
Re: Count the number of records in the sharepoint list within a day

@sbgoh

Set the Time Zone in SharePoint Online and the use the REST API approach that I suggested you in my previous update.

Open the SharePoint site on which you want to change the Time Zone.
On the Site Actions menu, choose Site Settings.
On the Site Settings page, under Site Administration, choose Regional settings.
On the Regional Settings page, select the Time Zone that you want for this site, and then choose the OK button.

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

Like (0)

Report
Re: Count the number of records in the sharepoint list within a day

Hi @sbgoh ,

You could refer to screenshot below to create the flow(Please leave the filter query field in the get items action blank):

The first expression in the Filter array action:

formatDateTime(item()?['issueDate'],'yyyy-MM-dd')

The second expression in the Filter array action:

formatDateTime(utcNow(),'yyyy-MM-dd')

The expression in the Compose for the number:

length(body('Filter_array'))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

I think my problem is related to time zone because for that 100 records that I created in the morning, I only able to get the count of 1 if I run the flow again in the evening. I still don't have a solution yet.

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

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

Hi @sbgoh ,

What is your local time zone?

You may take a try to add/sub some hours to meet the UTC time.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
sbgoh 284 on at

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

Hi Alice, it is Malaysia.

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

Like (0)

Report

Re: Count the number of records in the sharepoint list within a day

Hi @sbgoh ,

How many hours does the local time quickly or slow than the UTC?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No