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

Powerapps form and datatable doesn't recocnise the data type in SQL Server Datasource

I hope someone can help me out with this problem I have...

 

I have made a time write app with a form and a datatable on one screen (see screenshot below). In the form the user selects the project he has worked on, the activity, and the date and he writes a description, the amount of hours (uren), parking costs(parkeerkost) and kilometers (km). In the data table below, the items the user has previously written are shown. Everything works great, except for one (very important) issue. The data types for the hours, parking costs and kilometers are giving problems.

 

In the SQL Database the data types are exactly the same: Decimal(8,2).

But somehow in the data table and form properties the data types are shown differently:

Hours has data type 'numbers', parking costs has data type 'Text' and kilometers are 'numbers'.

Also in the data table itself the data is shown wrongly. Hours as a whole number, parking costs in the right way (i.g. 6,5), kilometers also as a whole number.

 

When I submit the form with the hours, e.g. 6,5, a mashup error shows up. When I submit the form with parking costs 6,5 the form works and when I submit the form with KM 6,5 it also works. However, the data in the data table is shown as a whole number (but the data is saved correctly in the database).

 

I just need to change the data types in the form and data table in such a way that we can write all the data in decimals.

 

It is a very annoying issue and I really hope that somebody can help me out because I need to start working with it asap.

 

 problem with datatypes.png

 

1 REPLY 1
v-yamao-msft
Community Support
Community Support

Hi Arjenvdbosch,

 

What’s your current situation?


What’s your location?


According to your description, I create a table in SQL server and add columns with the data type decimal.


Then create an app based on the table, both on a form and a data table control, they are shown properly. And I can save data to data source without issues.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,674)