Answered

Using UTC time not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All

I am trying to write a flow that references a table in excel, finds today's date in the list and emails that relevant person on that line. I am using the 'List rows present in a table' function with a filter on the DateText column (I have created a column in the excel table to convert the date to text). In the filter column I have put DateText eq '[fx UTCNOW('dd/mm/yy')]' (I have used the expression not just typed it). When I run the flow it seems to run but returns no results, when I check the flow it seems to create a random month, which means it returns no results. See screenshots below.

Thanks in advance for any help

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

I don't believe the issue is with utcNow(). Rather, your issue results from the fact that Excel store dates differently than Flow expects. Take a look at this blog post for a full explanation and a way forward.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@ScottShearer

Thanks for responding, however I already suspected that might be the case hence the reason I have created a column in my excel table to convert the date to text rather than, but if you look at my flow test results the utcnow() function has generated a random month it is generating '13/05/20' rather than '13/02/20' which is what I would expect.

Was this reply helpful? Yes No
Verified answer

RobElliott 10,426 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

In Power Automate months are always in upper case MM. Lower case mm is for minutes.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I have just tried removing the utcnow() function and manually typed in today's date and it worked fine, so there is clearly something I am getting wrong with the utcnow() function.

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous

Please see my flow below:
Replace 'Mountain Standard Time' with your time zone
The expression i am using is:
convertFromUtc(utcNow(),'Mountain Standard Time','dd/MM/yy')
Replace 'Mountain Standard Time' with anytime zone from here:
https://docs.microsoft.com/en-us/previous-versions/windows/embedded/gg154758(v=winembedded.80)?redirectedfrom=MSDN

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Well that was an embarrassingly simple fix... Thank you very much. I can't believe I missed that!!

Was this reply helpful? Yes No