Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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:

General topics

I have the same question (0)

All responses (2)

Answers (0)

AlanPs1 2,471 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report
Copy link

Link copied!

... 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.

Was this reply helpful? Yes No