Hi all,
I have a flow I’m trying to make where I take an increment valuable and create a percentage.
I have a flow for an evaluation SharePoint List where I’m trying to update some fields on a different SharePoint list that summarise the fields on the other list.
I have successfully created a variable for the count, an average of a column, but now I’m trying to create a percentage of an occurrence of some values in a column.
This column has 4 different possible values (Not at all Confident, Unsure, Confident, Very Confident). I want to find all the Confident and Very Confident for my percentage. I have successfully set up the condition and the output shows it is counting correctly. But then I am trying to then turn it into a calculation and falling short as the input and output is 0. Does anyone have any idea of how to help?
See my flow below, I’ve circled in red the parts that I can’t get to work.
div(variables('Confidence'),outputs('ItemTotal'))
but also tried
mul(div(variables(‘Confidence’),outputs(‘ItemTotal’)),100)
then the outputs:
working for increment
not working for compose
Solved! Go to Solution.
Hi @Lizzlenizzle,
Can you try and converting the integers to floats. For example try this expression in your compose action (with the name Division).
mul(div(float(variables('Confidence')),float(outputs('ItemTotal'))),100)
Hi @Lizzlenizzle,
Can you try and converting the integers to floats. For example try this expression in your compose action (with the name Division).
mul(div(float(variables('Confidence')),float(outputs('ItemTotal'))),100)
Amazing! It worked, thank you so much! Still getting used to using expressions so this was super helpful!!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
26 | |
24 | |
23 | |
14 | |
10 |
User | Count |
---|---|
57 | |
55 | |
29 | |
27 | |
24 |