cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Cal_Bun
Level: Powered On

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
Tow1994
Level: Powered On

Re: Problem trying to display dates from Dynamics CRM

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

Cal_Bun
Level: Powered On

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.

Tow1994
Level: Powered On

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

Cal_Bun
Level: Powered On

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

ReeceCampbell
Level: Power Up

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

 

Power Automate Staff JatinSanghvi
Power Automate Staff

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.

ReeceCampbell
Level: Power Up

Re: Problem trying to display dates from Dynamics CRM

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,042)