Quality Form Scores Computation

(0) Share

Report

Posted on by sandyabegail

Hi,

We have a Quality Assurance form in Excel which we hope to transpose to PowerApps.

I think I can manage building the form (layout and data submission). I would need help in getting/computing the scores. I really can't get my head around creating number formulas in the app.

I have attached the form with formulas that you can play around with.

Here's how it works:

1. The form has 2 main sections. Each section makes 50% of the overall QA score.

2. Each question will be rated as Yes, No, or N/A.

3. Each question has a point value of 1.

4. If the parameter is tagged as N/A, the point value should be set to 0, and should not be computed as part of the total possible points. You can see the total possible points in rows 110 - 126 of the excel file attached.

I would really appreciate it if you can help me replicate this form in PowerApps.

QA Form.xlsm

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @sandyabegail

Set the Default property of Value Text Control to
If(DropdownYesNo.Selected.Value="N/A",0,1)

Set the Default Property of Rating Text Control to
If(DropdownYesNo.Selected.Value="Yes",1,0)

Make sure to set the Text control format as Number

To Get the Sum of Value
Sum(BrowseGallery1.AllItems, Value(ValueTextInput.Text))

To Get Sum of Rating
Sum(BrowseGallery1.AllItems, Value(RatingTextInput.Text))

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @sandyabegail

Please let us know if anything needs on your post. We can help with this.

Please mark the post as Solved If I have answered your question.
Please give it a Thumbs Up if you find the suggestion helpful

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No