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.
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
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!