Hello,
I have encountered a strange problem with the CDS Get record action. My understanding is that a date field in Dynamics stores the date in UTC timezone and displays the date back to user based on user's timezone. If i use the Level Up Chrome Extension to view all the fields of a record in Dynamics 365, i can see the date field stored as a complete timestamp in UTC.
Data in Dynamics Form:
Data using Chrome Extension:
However when i retrieve the same record in a flow using the CDS Get record action, the same field displays only the date of the UTC timezone when it had to display the complete timestamp.
Data output of CDS Get_Record action:
Data output of CDS Get Record action with some fields spitting out the complete timestamp:
Any suggestions how i can retrieve the complete time stamp for the date fields? Thanks in advance.
Regards,
Nithin
Solved! Go to Solution.
I have tested this and these are my findings.
First I create two date columns Start Date (Date Only Format) and End Date (Date Time Format)
I have entered some data (dd/MM/yyyy) against these columns.
Start Date: 11-03-2020
End Date: 18-03-2020 17:00:00
Flow CDS Get Items returned the date values as follows:
Start Date
Start Date
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogProud to be a Flownaut!
Hi @Jcook ,
The issue is, when a record in CRM is saved with a date 12/03/2020, in CDS it is stored as 11/03/2020 14:00:00 UTC (Based on my local timezone - AU). Now if i access that field in a flow, i only get 11/03/2020 without the time. Even if i use Convert Time Zone action ( i have tried this), it takes the base time as 11/03/2020 00:00:00 and then converts it to my local timezone which is UTC + 10. So the converted time is still 11/03/2020 10:00:00 instead of 12/03/2020 00:00:00.
Unless i get the right timestamp there is no use in converting the timezone. I will have to account for the missing timestamp in my logic. Wanted a confirmation if this is the only way to tackle this or if i messing something up. Thanks.
Regards,
Nithin
I have tested this and these are my findings.
First I create two date columns Start Date (Date Only Format) and End Date (Date Time Format)
I have entered some data (dd/MM/yyyy) against these columns.
Start Date: 11-03-2020
End Date: 18-03-2020 17:00:00
Flow CDS Get Items returned the date values as follows:
Start Date
Start Date
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @abm ,
Let me give this a go. Will post back my results.
Just to confirm again, you are suggesting me to change the date field to date and time and then check with the CDS action? Thanks.
Regards,
Nithin
Yes that's correct.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogLearn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
User | Count |
---|---|
32 | |
31 | |
24 | |
24 | |
20 |
User | Count |
---|---|
59 | |
57 | |
43 | |
37 | |
28 |