web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Covert date field format

Power Automate

Answered

Covert date field format

(0) Share

Report

Report

Posted on by Ashwinreddy Microsoft Employee

Hi

Im trying to format the date from the list rows where the date field is coming as 2022-01-01T00:00:00Z , and this throws error on conditions

Scenario: i had field start date in one table

Start date in another table, but when the date is same it fails

As one come as 2022-01-01T00:00:00Z and another as

2022-01-01

Please help how to convert the field date from 2022-01-01T00:00:00Z to 2022-01-01 for particular FIELD

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Ashwinreddy ,

In the Condition control, you can use a formatDateTime expression to format all dates as 'yyyy-MM-dd'

formatDateTime(ExcelDateField,'yyyy-MM-ddT00:00:00Z')

Best regards,

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ashwinreddy ,
Can You Show Me Screenshot of action in edit mode where you try to formatDateTime.
If You are Using List rows present in a table of Excel Online Action, Then You Have to Set DateTime Format.

Was this reply helpful? Yes No

Join the conversation