Solved: How to Format the Date Time for Custom Field in MS...

Praveenpk365 · ‎06-20-2019

Hi Guys,

Im new to the flow. I would like to know how to format the DateTime of custom value (from Dynamics CRM) dynamically.

Current: 2018-05-29T16:33:16Z

Expected: 2018/05/29- yyyy/MM/dd

Refered some blogs, It was mentioned "formatDateTime(utcNow(),'yyyy/MM/dd');". This is working fine but, In my case I want to format the CreatedOn date And I'm expecting something like this formatDateTime(CreatedOn,'yyyy/MM/dd'); but CreatedOn is not listing in the Dynamics Content (snap below)

Please help me out If we have some other way to achieve this

yashag2255 · ‎06-20-2019

Hi @Praveenpk365

Please try using the expression:

formatDateTime(items('Apply_to_each')?['createdon'],'yyyy/MM/dd')

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

yashag2255 · ‎06-20-2019

Hi @Praveenpk365

Please try using the expression:

formatDateTime(items('Apply_to_each')?['createdon'],'yyyy/MM/dd')

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!