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.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,153)