web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter Array Date Ques...
Power Automate
Answered

Filter Array Date Question - Display items for Month

(0) ShareShare
ReportReport
Posted on by 8

I have a simple SharePoint list. 

ID | Title | Due 

1     Dave   01/15/2020

and created a workflow to fire the first day of each month. I.e 01/01/2020, 02/01/2020 etc. 

My goal is to go through my list, and email me a list of items with a due (date) occurring in the month. So if I run April 1, I should see items due for only April. If I run May, I should see items due only for May. 

 

For the life of me I can't grasp how to write the filter array. I found this;

@lessOrEquals(formatDateTime(addDays(item()?['Due'],30), 'MM/dd/yyyy') utcNow('MM/dd/yyyy'))

but it returns all items from the beginning. 

This returns everything from Jan through April. 

Categories:
I have the same question (0)
  • Min Rao Profile Picture
    187 on at

    @TxSteve 

     

    what about using startofmonth like following to compare two date ?

     

    equals(startOfMonth(variables('DueDate')), startOfMonth(utcNow()))

     

    CompareDateThisMonth.png

     

    result.png

     

    If I have answered your question, please mark your post as Solved.

  • Verified answer
    v-bacao-msft Profile Picture
    on at

     

    Hi @TxSteve ,

     

    Please try this configuration:

    82.PNG

    Feel free to let me know if you have any other questions.

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard