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?
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
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
178 | |
67 | |
36 | |
33 |
User | Count |
---|---|
341 | |
271 | |
115 | |
73 | |
58 |