Convert Date to Text to extract year in model driven app

(1) Share

Report

Posted on by Newtoapp

How do I extract year from created on column in a new column in model driven app?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

narayan225 2,547 Super User 2025 Season 2 on at

Like (1)

Report

@Newtoapp

You can use Power Automate for this purpose which gets triggered in record create and update.

Year formula only works for fields whose time zone adjustment is set to Time zone independent.

Because there is a time zone involved the Year formula doesn't have any support for time zone adjustment.

Cheers!

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (0)

Report

Hello,

I believe the easiest way is to use "Formula" field and Year function in it:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-datetime-parts

Was this reply helpful? Yes No
danc2 3 on at

Like (0)

Report

thanks so much!

Was this reply helpful? Yes No
guillem95 on at

Like (0)

Report

The function Year cannot reference a column in Dataverse, for example "Created on".
"Year cannot be performed on this input without a time zone conversion, which is not supported in formula columns." Any solution here? ¡Thanks!

Was this reply helpful? Yes No
federicomaslein 6 on at

Like (0)

Report

I get the same error message: "Year cannot be performed on this input without a time zone conversion, which is not supported in formula columns." when I sue the Year() function.
It should be great if someone find the solution.

I'm using a field with Time zone independent but not success 😞

Was this reply helpful? Yes No