web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get Items created in t...

Power Automate

Unanswered

Get Items created in the current month

(0) Share

Report

Report

Posted on by Mattw112b

1,088

I would like to generate a report of the items in a SharePoint list created in the current month.

So, if this is January 2020, I would like to Get Items from list with a filter query that returns only items created Jan1 - 31, 2020.

I was thinking something like this:

equals(formatDateTime(item()?['Created'], 'yyyy/MM'),formatDateTime(utcNow(),'yyyy/MM'))

That is giving me an error about first parameter needing to be a string.

How can I accomplish this on a filter query.

Thanks,

Terry

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Hi @Mattw112IG ,

I would make a test and would reply here once the flow is finished.

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

Like (1)

Report
Hi @Mattw112IG ,

The expression in the Filter Array should as below:

@and(greater(item()?['Created'], formatDateTime(utcNow(),'yyyy-MM-01T00:00:00Z')),less(item()?['Created'], addToTime(formatDateTime(utcNow(),'yyyy-MM-01T00:00:00Z'),1,'Month')))

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
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (2)

Report

Hey @Mattw112IG

You can do something like this:

Expression:

concat(utcNow('yyyy-MM'),'-01T00:00:00')

Hope this Helps!

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

Join the conversation