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