Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem trying to display dates from Dynamics CRM


Has anyone managed to display a date in a text box in PowerApps from data in Dynamics CRM Online?


I have tried every formula I can think of or find, but with no joy.


I would have thought that Text(ThisItem.scheduledstart, "dd/mm/yyyy") would work but does not.


Any help would be appreciated.



Regular Visitor

Does it display something without the Text() wrapped around?

Not applicable


No, unfortunately nothing displays if I select the date from the data source and don't add the Text().


I've tried it with other date field such as 'created on' which definitely have data and still get nothing displayed. I've tried all the variations of date formatting that I've found on this forum and still no joy.



Could you post a screenshot of your "App" with the control selected and its Text property-formula shown?

Otherwise I am doing guess work here

Not applicable

Screenshots below.
The field is within a gallery that is returning Service Activities (which is a type of appointment) from Dynamics CRM online - there are 2 records at the moment - hence the 2 rows.


I would like to show the Created On date from the returned data -  the first example uses the Text() format, the second just returns the field without any formatting. Nothing gets displayed for either.






Many thanks for your help

Not applicable



Has there been a resolution to this issue? I have the same thing.


I am in the UK and my computer is set to UK as is the CRM instance and I created a simple PowerApp App to show accounts with the createdon datetime and as you can see in the screenshots below they are being parsed incorrectly as US formated dates (11th August instead of the correct date of 8th November) and showing where the system can understand the date and blank when not (actually contains the default DateTime value of 01/01/1900).


I can see no way to change this as it appears to be the way PowerApps parses the data returned from the CRM and I cannot interfere with this.






Reece, we have addressed the issue in Dynamics 365 connector for PowerApps. The fix should have been deployed in mid of December. Let us know if you still find problem.

Not applicable

Thanks @JatinSanghvi, that appears to be working properly now 🙂

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,178)