Power Automate - Calculate Percentage

[Bhanu2023]

Hi, Here is the Scenario. I have a array from Sharepoint list - Ex . [SETT, RATT, INV] and I am able to pull it and Able to count as 3. Now I want to use a condition - if count = 0-5 then do a calculation - count *15% -( 3 * 15% ), if I have a array with count 6-10 then do a calculation of 6 *25% / 7*25% on the basis of count. Please guide me how to do that and store it. 

[Bhanu2023]

.

[efialttes · Accepted solution]

Hi @Bhanu2023 !
I am assuming your input is an Array, so PowerAutomate can store it as an Array variable , right?
If so, I would suggest to use the WDL function length() as in the following example:

Please also note in my test flow I am not getting the array from Sharepoint, but from a variable I just initialized with the array example you provided.
The point is: length() will provide you the nr of items inside your array.
Now you have stored nr of items in a variable, I would configure Condition rules as the following:

You can add more than one condition rule in a single 'condition' action block; just click on 'add' button
Hope this helps!

[trice602]

Hi @Bhanu2023 ,

Your math formula would also look like this:

formatNumber(mul(variables('MyVar'),0.15),'F2')

[Bhanu2023]

Hi, I am able to calculate up to length of array. Issue is how I will do this calculation in the condition and store the value so I can use it next steps. if count = 0-5 then do a calculation - count *15% -( 3 * 15% ), if I have a array with count 6-10 then do a calculation of 6 *25% / 7*25% on the basis of count.

[Bhanu2023]

Thanks . Hi, I am able to calculate up to length of array. Issue is how I will do this calculation in the condition and store the value so I can use it next steps. if count = 0-5 then do a calculation - count *15% -( 3 * 15% ), if I have a array with count 6-10 then do a calculation of 6 *25% / 7*25% on the basis of count.

[trice602 · Accepted solution]

Hi @Bhanu2023 ,

Here's the conditional step:

Next you would use compose expression:  

formatNumber(mul(variables('MyVar'),0.15),'F2')

[Bhanu2023]

Hi @trice602 ~ That’s helpful.  I have 4 condition if count is 0-5 then 15%, 6-10 then 25%, 11-15 then 50% , 15 + then 100%. Then I need to multiply weightage 15% with the above 4 output and store it. 

[trice602]

Hi @Bhanu2023 ,

Here's one way of many ways to achieve this.  In this example, I assign a value to the bucket (count), 15% = 1, 25% = 2, 50% = 3, everything else 4, then switch and use cases.

if(lessOrEquals(variables('MyVar'),5),1,if(lessOrEquals(variables('MyVar'),10),2,if(lessOrEquals(variables('MyVar'),15),3,4)))

Then for each case, I do the math inside a Set variable action and then continue to use the variable downstream.

[Bhanu009]

@trice602 Thanks for the solution. I will try it.

[Bhanu2023]

@efialttes - could you please in the above example -how can I do calculations and store the result  after that so I can use it .  if count = 0-5 then do a calculation - count *15% -( 3 * 15% ), if I have a array with count 6-10 then do a calculation of 6 *25% / 7*25%