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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use utcnow('mmm...
Power Automate
Unanswered

How to use utcnow('mmm') to filter Excel rows based on month match for a date

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Trying to pull rows from an excel to filter, save to a list and then email.

1) Assuming Excel "Current Hire Date" comes in as string (source is custom: 14-Sep-15 12:00:00 AM), Im not sure why both a Condition and filter array fail --> [Current Hire Date] Contains [utcnow('mmm')]. Is there an expression to convert to string?

2) Is there anyway to avoid having to "Format the Table" in order to make excel columnms available for flow?

 

 

Categories:
I have the same question (0)
  • AlanPs1 Profile Picture
    2,471 on at
    Hi Cowansc

    Please see this post - https://www.alanps1.io/power-platform/flow-testing-various-date-formats-from-any-source/

    I am not able to work through this detail for you right this moment but I posted this earlier. I should help you generally work with dates / times and there are some handy reference links in it too. Have a go and come back and let us know how you’ve gotten on please.

    Thanks, Alan.
  • AlanPs1 Profile Picture
    2,471 on at
    ... and yes, string() converts to string but I’d suggest looking at all the date and time stuff before using that as you’ll likely find your answer within those. The Workfkow Definition Language Function Reference in the post will explain string() and all other functions that make up expressions.

    Thanks, Alan.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard