cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Problem trying to display dates from Dynamics CRM

Hello,

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.

 

Thanks.

7 REPLIES 7
Highlighted
Regular Visitor

Re: Problem trying to display dates from Dynamics CRM

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

Highlighted
Anonymous
Not applicable

Re: Problem trying to display dates from Dynamics CRM

Hello,

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.

 

Thanks.

Highlighted
Regular Visitor

Re: Problem trying to display dates from Dynamics CRM

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

Highlighted
Anonymous
Not applicable

Re: Problem trying to display dates from Dynamics CRM

Hi,
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.

 

Date-1.jpg

 

Date-2.jpg

 

Many thanks for your help

Highlighted
Anonymous
Not applicable

Re: Problem trying to display dates from Dynamics CRM

Hello,

 

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.

 

CRMAccounts.pngPowerAppsAccounts.png

Cheers,

Reece

 

Highlighted
Power Automate
Power Automate

Re: Problem trying to display dates from Dynamics CRM

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.

Anonymous
Not applicable

Re: Problem trying to display dates from Dynamics CRM

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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