cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bduan
Frequent Visitor

Custom Card format issues

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?

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,198)