I would like to create a flow that will count the total entries recorded in a SharePoint list in the last 24 hours. I would need this to be done everyday. For example: Today is Thursday June 24th, I would like to the flow to count the total received entries on Wednesday June 23.
Thanks for your help.
Solved! Go to Solution.
I think something like this can work
That's it, just remember to change the Pagination configuration in the "Get items" action settings.
Let me know if that helps.
Hi @AnthonyAmador ,
Thanks so much.
I'm getting warning saying to use OData filter. I tested the flow, but it's taking time to run.
Any help with this?
Thanks so much!
The delay time I put it at 23 hours, because you say you need it every day, that's probably why is taking time, but if you want to test how it works, change the delay to 1 minute and add items to the list in that time.
The warning its for performance improvement in this case you can ignore it, but if you want to know how to use the OData filter, check this blog.
Hope this helps.
I've been trying the flow (set delay to 1min), but for some reasons I get the same value for each test. Is this okayÉ
I have 2000+ items, but I'm only interested in knowing how many new items were recorded in the last 24 hours. Basically I want to get total count of new items in the last 24 hours.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.