web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Trouble with convertin...
Power Apps
Unanswered

Trouble with converting numers

(0) ShareShare
ReportReport
Posted on by 79

Hi. I am trying to adopt the milestone app. I keep getting an error message (several actually) on different places in the app that seems to be related to sizing of different fields. The error message is e.g; value 0.73456 can not convert to a number. It is related to these formulas and i can't figure out what's wrong. Any help appreciated. This is the "code":

 

Switch(
gblUserLanguage;
"ja-JP";
50 * 1;
Min(
Sum(
AddColumns(
Split(
Self.Text;
""
);
"Size";
LookUp(
colCharsWidth;
CharFont = Self.Font && CharWeight = Self.FontWeight && Char = Result
).Size
);
Size
) * Self.Size + Self.PaddingLeft + Self.PaddingRight + 2;
100
)
) +17

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @lejo_69 

    I suspect the problem is that the added column is from a Textinput box and is interpreted by PowerApps as text.  Also "Size" is a reserved word so it may be causing confusion.  Perhaps you could rename it in your formula and wrap is inside Value(). 

  • lejo_69 Profile Picture
    79 on at

    Thank you. This "code" is from the Microsoft team that has built the Milestones app for Teams and Powerapp studio. Tried some tweeking but no solution so far.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard