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')}'

Categories:

Building flows

All responses (12)

Answers (1)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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!
sbgoh 284 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CFernandes, it only return 1 record for me.
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
sbgoh 284 on at

Like
a
(0)

Report
Copy link

Link copied!

There is timezone issue but I am unable to solve it. My issueDate is a date time field.
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@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.
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.
sbgoh 284 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
sbgoh 284 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Alice, it is Malaysia.
v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.