How to change card type from string to number

(0) Share

Report

Posted on by Lucian

256

Hello,

I have an app connected to an Excel file and when created I did not pay attention to proper formatting columns in Excel.

So, I have some datacards that were considered Text, I could do some calculateions based on them, but after some changes, including proper formatting columns in Excel as numbers, I cannot save data.

I receive an error "The requested operation is invalid. Server Response: Invalid value '100' for field 'LastValue', expected a number."

I have tryied to put in the Update property Value(LastValue.Text) but no luck.

I have try to add the field again but when I check the data card will show "abc" insetead of "123".

So how can I corred the data source so I could work now with numbers and the data card be recognized as number?

Kind regards,

Lucian

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

dinusc Microsoft Employee on at

Like (1)

Report

Have you tried setting the TextInput control format to "Number"? (LastValue.Format=TextFormat.Number)

Was this reply helpful? Yes No
Verified answer

v-micsh-msft on at

Like (0)

Report

The quick workaround here should be re-format the column type within Excel from number to string, then if you need to do some calculation within PowerApps, then use the Value() function to convert it.

Regards,

Michael

Was this reply helpful? Yes No
Lucian 256 on at

Like (0)

Report

Thank you dinusc for your message, I forgot to mention that I have already tried formatting the TextInput but the error was the same.

Was this reply helpful? Yes No
Lucian 256 on at

Like (0)

Report

Thank you v-micsh-msft for your suggestion, I woll keep in mind this.
Meanwhile, I solved the problem by logging-off, close all browser windows and create a new screen, so when the field was added was interpreted correctly as number.
The bad part was that I had to re-make all of the settings and formulas... but in the future, maybe Microsoft will do some updates that could make this kind of changes easier... 😉

Kind regards,
Lucian

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Michael,

Xavier here. I tried doing the same thing with my application, and now the number display is missing and my number edit form is back to "1". May I know what is going on?

Thank you and have a great new year ahead!

Xavier

Was this reply helpful? Yes No