Power Platform Community Forum Thread Details

Hi.

I have a report that one of my colleagues download from the azure active directory. That report is the Devices list. That report has 3 dates columns as follow:

approximateLastLogonTimeStamp

lastDirSyncTime

registrationTime

The outputs for those columns are in this format : i.e. 8/25/2015 4:46:01 AM

I have been trying to copy that report into a share point list but for some reason the date columns are a huge pain in the neck. Flow fails or if I connect my powerapp to the excel is really hard to get the dat in a proper way.

Somebody told me to convert the date columns using the convert time zone.

In that columns I have some empty values. The rest seems like is OK. But I am getting this error:

Unable to process template language expressions for action 'Convert_time_zone_lastDirSyncTime' at line '1' and column '26998': 'In function 'converttimezone', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

If the report came from a third party source I will be OK, but c'mon this is from AAD should be straight forward. Unless I am doing something wrong?

Any help please?

And thanks in advance.

Categories:

General topics