cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Prakash
Frequent Visitor

Canvas App : Changed data type of column in sql server database and refreshed the datasource in PowerApps .Dont see the change in PowerApps

 I have few data cards on form which are of date-time data type .I created a canvas app that connects to these date-time data type fields in table .

Even I change the datatype of these datetime fields to date in database ,refreshing data source(table) in PowerApps, I don’t see the value of date time data card  changed to date .

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User III
Super User III

Hi @Prakash 

When you modify a data source, the cards on the form won't automatically change to reflect changes in the data types of fields.

You'll need to remove the card and to re-add it if you need an auto generated card that includes the time entry fields.

Also, it's worth noting that when you change the schema of a SQL table, it can sometimes take a while for PowerApps to recognise the change. Therefore, if this doesn't work immediately, I would recommend waiting for a bit before trying again.

View solution in original post

2 REPLIES 2
timl
Super User III
Super User III

Hi @Prakash 

When you modify a data source, the cards on the form won't automatically change to reflect changes in the data types of fields.

You'll need to remove the card and to re-add it if you need an auto generated card that includes the time entry fields.

Also, it's worth noting that when you change the schema of a SQL table, it can sometimes take a while for PowerApps to recognise the change. Therefore, if this doesn't work immediately, I would recommend waiting for a bit before trying again.

View solution in original post

Prakash
Frequent Visitor

Thanks for the Response and Correct solution . It worked for me

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (95,881)