Common Data Service Date value and Calculated columns
I have a couple of issues when using the common data service and I hope you can help.
1) The do not appear to be any calculated fields within the entities of the common data service.I am able to provide the calculations by adding a text box and performing calculations using the formula bar of powerapps however these fields are not then exportable when I am trying to export the data for reporting purposes. What I am looking for is a calculation field that refers to the other fields within the same entity.
2) I imported data into the common data service via excel. One of the columns were dates in the format of dd/mm/yyyy. for some reason this is displayed as m/dd/yyyy, 02:00 am. I can understand the regional settings are not configured for the UK ( which I will correct shortly) however I am unsure as to why the sate has 02:00 am included. I have applied a date filter within powerapps however this is not working and I believe it's down to this issue.
About question#1, do you want to have a calculation field within the entity? It seems that currently CDS don’t support calculation field, you could consider to create a request at PowerApps Ideas Forum.
We can achieve this on PowerApps. Say I have a custom EntityA which contains three Number columns, column name are number, Number1, Number2.
Then create an auto-generated app based on this entity. On the EditForm screen, unlock the Number field, then set its Default property as DataCardValue15.Text*DataCardValue16.Text.
When values are entered in the Number1 and Number2 field, the number field would be calculated automatically. And it can also be saved to the entity.
About question#2, what’s the field type for the Date column? Is it a Date field or DateTime field?
According to this documentation about “Import or export data from the Common Data Service”, I test this issue with EntityA. I can import the data from Excel to EntityA with correct format.