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

change datatype

Hi,

 

I've created a small app based upon a table in SQL Azure.

Originally the field UseDate was of the Date Format. Mean while I've changed the data type to varchar(255)

 

i've refreshed the table in PowerApps client. I use it without any problems to filter a BrowseGallery.

But when going to the EditScreen the field UseDate is still of the type DateTime.

 

Where can I change this? (Because now he is showing 10/10/2016 02:00:00. But in the table there is only 10/10/2016.

 

Regards,

Nico

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff rgruian
Power Apps Staff

Re: change datatype

Try generating your app again or removing and re-adding a card for that field whose type has changed. If a form was already generated for your data source, and the existing cards use a specific type of formatting for your data (in this case a date&time format), refreshing the data source will not necessarily change that initial formatting.

 

I hope this helps.

Radu Gruian [MSFT] ** PowerApps Staff

View solution in original post

5 REPLIES 5
Perumal
Level 10

Re: change datatype

Try removing the SQL connection and add again.

Power Apps Staff rgruian
Power Apps Staff

Re: change datatype

Try generating your app again or removing and re-adding a card for that field whose type has changed. If a form was already generated for your data source, and the existing cards use a specific type of formatting for your data (in this case a date&time format), refreshing the data source will not necessarily change that initial formatting.

 

I hope this helps.

Radu Gruian [MSFT] ** PowerApps Staff

View solution in original post

verbani
Level: Powered On

Re: change datatype

That did the trick. 

 

Thx

 

Highlighted
Arjenvdbosch
Level: Powered On

Re: change datatype

Can you remember what exactly 'did the trick'? I am having the same issues... Any help is much appreciated!

rgparisoto
Level: Powered On

Re: change datatype

It help me! Tks.

Helpful resources

Announcements
thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (4,802)