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.
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.
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
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.
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021