Unanswered

Control Type incorrect in Data Table

(0) Share

Report

Posted on by gaborszollosy

Greetings, friend!

I apologize for my obvious ignorance but I have strived and - to my immense disappointment - failed to set the Control type in a Data table to accurately represent float type numerical data collected from the, might I add, correctly formatted Excel table column.

As you can surely observe in the above image, the Data type is identified as string and the Control type as text column. These assumptions made by Power Apps, however, are false. I would very much appreciate the assistance of a fellow user in coercing the Data table into correctly identifying said values as float type numerical values.

With high spirits and everlasting hope,

Gabor

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @gaborszollosy

If you're using the Excel Online Business Connector, it doesn't support properly support numeric and date data types. If this is the case, you can use the OneDrive connector instead, but this will limit you to accessing the first 2000 rows from your spreadsheet only.

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Excel-Online-Business-Connector-Add-support-for-number-numeric/idi-p/936194

Was this reply helpful? Yes No
gaborszollosy 71 on at

Like (0)

Report

I understand. And is there a way to convert the Data table column string values into summarizable numerical values?
I want to add together all visible rows of data in one column so I can get a sum point value, and a sum work hours value from the same Data table.

Thank you for your continued help @timl!

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @gaborszollosy

To display numeric values in the datatable, you would set the items property to this:

AddColumns(YourExcelDatasource, "YourFieldNum", Value(YourField) )

This adds a column called YourFieldNum that contains the numeric representation of YourField.

To sum all of the values, you would use this:

Sum( AddColumns(YourExcelDatasource, "YourFieldNum", Value(YourField) ), YourFieldNum )

Was this reply helpful? Yes No
gaborszollosy 71 on at

Like (0)

Report

Thank you very much, @timl, this is exactly what I needed!

Was this reply helpful? Yes No