Power Up Program - Create Power Automate cloud ...

Problem running a flow with date

(1) Share

Report

Posted on by MM-06051525-0

Hi I am working on creating Power automate cloud flow for Power Up challenge. The flow is failing with the below error.

I am using the code for Variable Start Day :

convertTimeZone(utcNow(),'UTC','GTB Standard Time','yyyy-MM-ddT00:00:00.000Z') and for variable Endof Day:convertTimeZone(utcNow(),'UTC','GTB Standard Time','yyyy-MM-ddT23:59:59.000Z'). My time zone is Easter Europe. How should i fix this. I undestand that the issue is the time zone.
 
Thanks
Maria

Categories:

General Discussion

All responses (2)

Answers (0)

MM-06051525-0 21 on at

Like (0)

Report

Problem running a flow with date

Hi,

thank you for your help,

I changed as per below but i still receive the same error.

Might be is the format of the column mm_ParkingRequestDateTime in ParkingRequests table that needs to changed? Is a Date and Time.

Thanks

MAria
Suggested answer

SudeepGhatakNZ 14,371 Most Valuable Professional on at

Like (0)

Report

Problem running a flow with date

Try

Start date

formatDateTime(convertTimeZone(utcNow(), 'UTC', 'GTB Standard Time'), 'yyyy-MM-ddT00:00:00zzz')

End date

formatDateTime(convertTimeZone(utcNow(), 'UTC', 'GTB Standard Time'), 'yyyy-MM-ddT23:59:59zzz')

The key change is using 'zzz' instead of 'Z', which appends the correct timezone offset (like +03:00)