web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Quality Form Scores Co...

Power Apps

Unanswered

Quality Form Scores Computation

(0) Share

Report

Report

Posted on by sandyabegail

32

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

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

Join the conversation