Custom Card format issues

[bduan]

If I go to my .xlsx table that my data is connected to and change the format of a column to 'Number' rather than 'General', my forms will all return errors such as:

Invalid value '100' for field 'xyz', expected a number.

I cannot find where in the advanced fields where I can specify the format of the card output when the form is submitted. Is there a way to fix this?

[v-micsh-msft]

You could switch the TextInput  control format property to number instead of Text.

"

Format – Whether the user input is restricted to numbers only or can be any text

"

Further, we may switch the string format into number by Value function,  under the DataCard Update property, switch the formula as below:

Value(DataCardValue.Text)

Which should convert the string into Number.

Regards,

Michael

[bduan]

It didn't work. I should mention I'm using a "Rating" control card

I switched the Update field to

 Value(Rating.Value)

It makes zero sense why this wouldn't work but it's still returning "Invalid value '3', expecting a number"

Edit: It didn't work for a standard text box input control card either. It works if I save the column type in the table as 'General' but the formatting seems to constantly switch around.