Answered

Power Apps "This formula currently uses a range that is not supported for calculations"

(0) Share

Report

Posted on by Martyna1107

I have a table in Sql server that I cannot edit. It has several nvarchar type columns and columns named 2022-07 etc. These are of type float. I created a gallery in powerapps to which I manually add text labels (ThisItem.Key for example) Everything is fine until I get to the float type columns. Powerapps prompts me to then save the code as ThisItem.'2022-07' but at that point I get an error and in addition all the other gallery elements that were previously working properly disappear and I can only restore them by adding the gallery from scratch. As for the values in the 2022-07 column, they are, for example, 100, 121.97 and 0.

The error as in the title

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@Martyna1107

To clarify, was '2022-07' originally an nvarchar column that you subsequently changed to float? If so, have you refreshed the data source in Power Apps?

Was this reply helpful? Yes No
Martyna1107 35 on at

Like
a
(0)

Report
Copy link

Link copied!

No, in the table there are columns of type nvarchar - everything is fine with them - and of type float (2022-07). The column type was defined when the table was created and has not been changed since. On the other hand, I have already tried refreshing the data source, deleting and adding them again. Also if it will helps - these columns are set up as not null. I worked with PowerApss before and I didn't have such a problem - but I have never worked with float type column

Was this reply helpful? Yes No
Martyna1107 35 on at

Like
a
(0)

Report
Copy link

Link copied!

No, in the table there are columns of type nvarchar - everything is fine with them - and of type float (2022-07). The column type was defined when the table was created and has not been changed since. On the other hand, I have already tried refreshing the data source, deleting and adding them again. Also if it will helps - these columns are set up as not null. I worked with PowerApss before and I didn't have such a problem - but I have never worked with float type column

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Assuming you just want to display the value in the gallery, if you call the Text function, does that make a difference?

Text(ThisItem.'2022-07')

Was this reply helpful? Yes No
Martyna1107 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I just want to display that value. Unfortunately Your solution doesn,t work, as soon as I type it in formula bar everything dissapear in my gallery

Was this reply helpful? Yes No
Martyna1107 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I just want to display that value. Unfortunately Your solution doesn,t work, as soon as I type it in formula bar everything dissapear in my gallery

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

In the settings of your app, is the 'formula-level error management' setting enabled? If not, could you try enabling it to see if it makes a difference?

Was this reply helpful? Yes No
Martyna1107 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it has been enabled since the application was created

Was this reply helpful? Yes No
Martyna1107 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I just checked the operation on another table, the float column values display normally but also there are no floating point numbers in the data. Only values such as 0 or 2

Was this reply helpful? Yes No
Verified answer

Martyna1107 35 on at

Like
a
(0)

Report
Copy link

Link copied!

The problem was column names starting with numbers. I changed it to sth like Date:2023-07 and it works perfectly fine

Was this reply helpful? Yes No