Unanswered

Approval using Forms - calculate a percentage between two answers then create a condition where the request is denied if the value is above a certain percentage?

(0) Share

Report

Posted on by KBeale

312

Is it possible to calculate a percentage between two answers from the Form and then create a condition where the request is denied if the value is above a certain percentage?

Here's my scenario. I'm creating an approval process for policy where staff can use up to 10 percent of their hours/ month for activities that are not in their job description. In my Form, question 4 asks how many hours they work/ month, and question 5 asks how many hours/ month are required for the activity being approved. Could I use Power Automate to automatically determine if the answer to question 5 is over 10% of the answer to question 4, and then reject the request if so?

Thanks in advance for your insight!

@Pstork1

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

Yes, Power Automate can do that kind of math. But it would take me a little time to come up with the exact method and formulas. One of the issues will be translating between strings and numbers at the right time. But yes it can be done.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (1)

Report

Hi @KBeale ,

We could calculate the percentage between the two answers and send the percentage to the approver, however the Approval couldn't be response automatically in Microsoft flow currently, the approver could only make the response to approve or reject manually.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
KBeale 312 on at

Like (0)

Report

Ah ok that makes sense! Could you tell me the steps to calculate the percentage? Or point me toward resources that could get me started trying to figure it out myself? Thanks! 🙂

Was this reply helpful? Yes No