Service | Customer Service, Contact Center, Fie...

Powerapps export to datalake, Azure data factory ingestion

(0) Share

Report

Posted on by Scosec

Hi Guys,

I'm not sure i'm targetting the right forum for my question. Since this involves dynamics CE data export i'll try here.
There might be an overlap with Azure data factory

Using the following docs i have created a export to our datalake:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/export-to-data-lake

The export is working quiet perfect. Our data lake contains a export with the common data model (CDM). and it's data files.
Using the mapping data flow in Azure Data Factory i'm reading the common data model. Which works for all fields except date columns.

All dates appear to be blank/null when previewing or processing the data with ADF (mapping data flows).It appears there is a misunderstanding between (my guess) the date format.
The export has date fields in following format: 2020-11-03 09:25 AM. I'm thinking that the common data model expects it as the following format: 2020-11-03 09:25:00

Are there more people experiencing similar issues?

Thanks in advance.

Ivo

All responses (5)

Answers (0)

Suggested answer

Scosec 95 on at

Like (0)

Report

RE: Powerapps export to datalake, Azure data factory ingestion

Hi,

Yes, they responded with the following images. You can set additional (accepted) datetime formats as following:
kb8787 5 on at

Like (0)

Report

RE: Powerapps export to datalake, Azure data factory ingestion

Did you ever find a resolution for this from the ADF product team?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Powerapps export to datalake, Azure data factory ingestion

Hi Scosec

OK! Hope your problem will be resolved.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Scosec 95 on at

Like (0)

Report

RE: Powerapps export to datalake, Azure data factory ingestion

Hi,

Thanks for your reply. This involves the GUI and is not where the issue lies.

ADF product team is currently investigating.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Powerapps export to datalake, Azure data factory ingestion

Hi Scosec,

The default datetime field format is 12 hrs, what you need is 24 hrs.

1.You can go top corner gear icon > Personalization Settings.

2.Go to Formats tab and click Customize button.

3.Go to Time tab and select H:mm in time format, then click Apply and Ok button.

4.Refresh page, you will find datetime field value is 24 hrs format.

Also. You notice that time format is 17:30 not 17.30.00, which is because D365 do not support show seconds in datetime field, this is by-design.