Power Automate - Multiplication using cost in SharePoint List x total hours on Microsoft Forms

(1) Share

Report

Posted on by Automato

I have a form that people submit job requests, I want to calculate the cost of a job using a per hour figure on Sharepoint list and multiply using total hours on Microsoft form. I then want to include the sum on an approval notification so that budget holders are aware of the total cost of the request.

What is the best way to do this?

Thank you very much

I want to include the sum and show it as dynamic content on approval notification

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Sayan 818 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hey,

You can initialize a variable and, on that variable, you can calculate the sum and you can use anywhere in the flow as a dynamic content.

Solution:

Initialize a variable

On the value field you can calculate the Sum.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if my suggestion helps you, gives it a Like and Marks as a Solution. Which motivates me to solve more problems.

Thanks,

Sayan Patra

RPA Developer

Was this reply helpful? Yes No
Suggested answer

AnthonyAmador 2,557 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

First, you need a way to categorize the student submitting the form to compare against the SharePoint list and extract the hourly cost for that student. For example, “Student Helper (Grade 2)” or “Student Invigilator (Grade 3).” I suggest adding a predefined unique selection in the form for the title that the student selects.

Use SharePoint Get Items action to retrieve all items, then use a for loop to get the column information you need based on the student category. After that, you can extract the cost per hour for that specific student, multiply it by the number of hours, save it in a variable, and then add it to the approval request.

Hope this helps,
Anthony.

Was this reply helpful? Yes No