cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NikTan
Level: Powered On

Count of Record of current month from List

Hi Mates,

I am trying to Get Item Count for Current month but i am unable to get records.

I follow the below article but query is not working.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/retrieve-records-created-only-for-the-cu...

 

 

Please let me know how i can get Count of Record of current month from List.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Count of Record of current month from List

So I just verified that the solution you found does work. Did you make sure that you put the expressions in single quotes? So in your Get Items Filter section you should have something like this: Created ge '@{startOfMonth(getPastTime(0,'MONTH'))}' and Created le '@{startOfDay(utcNow())}'

View solution in original post

1 REPLY 1
Super User
Super User

Re: Count of Record of current month from List

So I just verified that the solution you found does work. Did you make sure that you put the expressions in single quotes? So in your Get Items Filter section you should have something like this: Created ge '@{startOfMonth(getPastTime(0,'MONTH'))}' and Created le '@{startOfDay(utcNow())}'

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (3,727)