You’re offline. This is a read only version of the page.
Announcements
100
Hello community,
I need to extract the Year Value of a DateTime Column, let's call it 'Actual End' and save it in another column. So I want to create a formular column or calculated column for this.
It might be so that I can't use Power Apps Functions to grab the year value since
Year('Actual End') is not working here but in Power Apps.
The given error is: Year cannot be performed on this input without a time zone conversion, which is not supported in formula columns.
Any ideas?
Thank you for any help!
Calculated columns against Date columns are currently problematic in Dataverse. Although many functions are supported (DateAdd, DateDiff, Days, Weekday, Year etc), attempting to apply this to a PowerFx formula will return that error.
This is due to the lack of support at present for the localisation of Dates in Dataverse. Time zone conversion is not yet supported in calculated Dataverse columns.
You can find detailed information about this here:
http://powerappsguide.com/blog/post/dataverse-formula-columns
As an alternative, I would suggest using Power Fx on a Canvas App, or use Power Automate to achieve this.
Share
Report
All responses (
Answers (
