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

Notifications

Announcements

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)
  • 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.

  • 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(). 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 403

#2
WarrenBelz Profile Picture

WarrenBelz 338 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 320 Super User 2025 Season 2

Last 30 days Overall leaderboard