Unanswered

How to use PowerApps to display some columns along with calculated results in MS Forms?

(0) Share

Report

Posted on by IL-24011540-0

From PowerApps if the following information is displayed below, how to get all the columns to show in MS Forms with calculation generated?
The following column allows user input.
- Hours Worked

The following column displays the Rate Per Hour along with the hours the user has inputted.
- Equation Display

The following column shows the calculation.
- Total to Pay (with 13% Tax)

Resource Name	Rate Per Hour	Hours Worked	Equation Display	Total to Pay (with 13% Tax)
Baby Shark	$10	3	$10 * 3 hrs* 1.13	$33.90
CocoMelon	$20	2	$20 * 2 hrs *1.13	$45.20

Categories:

Connector development

I have the same question (0)

All responses (2)

Answers (0)

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

HI IL-24011540-0

Create input fields in Microsoft Forms for the required columns. You will need: A Text Field for "Hours Worked" (for user input). A Text Field for "Rate Per Hour" (for user input).

Use Power Automate to calculate the "Equation Display" and "Total to Pay (with 13% Tax)" based on the user inputs from the form submission: Use a formula in Power Automate to calculate the values, Total to Pay = Rate Per Hour * Hours Worked * 1.13

Send the result (calculated Total to Pay) to a SharePoint list or Excel for reference, or use email notifications to send users the result.

thanks

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @IL-24011540-0,

If you are asking how to fill MS Forms with data from Power Apps, the answer is that you cannot pre-populate any data into this facility (other than hard-coding it into the design). There is also to facility in MS Forms to do calculations.
If you are asking how to take user input data in MS Forms and send a calculated result back to a Power Apps data source (SharePoint etc), then @SaiRT14's response is correct and you would either do this in Power Automate or bring the "raw" data back into the data source using Power Automate and calculate in Power Apps when you opened the record next.

Was this reply helpful? Yes No