cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tianaranjo
Level 8

Equation - Round, Percent, Mid

Greetings,

 

Problem:  Multiple 'labels' for one result

Desired Solution:  Consolidate into one label

 

Label 1  --> Text -->: 'Width (L2)'/ 1233 * 100 & "%" --> Result = ##.########, (ex:  63.77737226)

Label 2 --> Text --> Round(100% * ( 'html_Width (L2) in %'), 2) --> Result = 0.## (ex: 0.64)

Label 3 --> Text --> Mid('html_Width (L2) in %_3'.Text, 3, 2) &Mid('html_Width (L2) in %_3'.Text, 5,6) &"%" --> Result = ##% (ex: 64%)

 

Ultimately, I need the final result.  Any suggestions on consolidating from 3 (calculation) labels into 1?

1 ACCEPTED SOLUTION

Accepted Solutions
tianaranjo
Level 8

Re: Equation - Round, Percent, Mid

I think I have it figured out:

Round(
((UserInput2 - UserInput1) * LineScale + varWidth) / VarLineWidth * 100, 0) & "%" 

I know it is hard to make sense of without understanding how the app is built.  This essentially is used to determine how to set the width of a table cell based on user inputs, overall width of a table, width of the first cell in a table.  

View solution in original post

1 REPLY 1
tianaranjo
Level 8

Re: Equation - Round, Percent, Mid

I think I have it figured out:

Round(
((UserInput2 - UserInput1) * LineScale + varWidth) / VarLineWidth * 100, 0) & "%" 

I know it is hard to make sense of without understanding how the app is built.  This essentially is used to determine how to set the width of a table cell based on user inputs, overall width of a table, width of the first cell in a table.  

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 105 members 5,696 guests
Please welcome our newest community members: