Power Platform Community Forum Thread Details

HI all,

Wondering if you can help. Building Powerapp->Sharepoint list->PowerBI

Im creating a powerapp to capture different aspects of a process for Quality Assurance. Basically what happens is the user will go into the App, and for each criteria/question mark yes/no based on their investigation. Each Yes/No will have a weighting to it and adds up to an overall score. That score will then determine whether the process sampled is overall Pass or Fail (eg over 80/100 = pass)

Whats the best way to achieve this? Any examples/screenshots helpful 🙂

EDIT: Have added screenshot what i have done so far, ive got some calculations in there but want to have the "Pass" in result field and "80" in the score field and for them to be read only. (at the moment they are just calcuating in a random part of the app)

Thanks!

Categories:

Building Power Apps

Hi @karlosch :

Could you tell me what the data types of these 8 fields are? What are the corresponding controls?

I assume:

The 6 questions and "Result" are chocies type and do not allow multiple selections.
"Score" are number-type field.

I've made a test for your reference:

1\Set the ScoreTextInPut's Default property to:

100+
If(Q1ComboBox.Selected.Value<>"Yes",-10,0)+
If(Q2ComboBox.Selected.Value<>"Yes",-10,0)+
If(Q3ComboBox.Selected.Value<>"Yes",-10,0)+
If(Q4ComboBox.Selected.Value<>"Yes",-10,0)+
If(Q5ComboBox.Selected.Value<>"Yes",-10,0)+
If(Q6ComboBox.Selected.Value<>"Yes",-10,0)

DisplayMode

DisplayMode.Disabled

2\Set the ResultComboBox's DefaultSelectedItems property to:

If(
 (100 + 
 If(Q1ComboBox.Selected.Value <> "Yes",-10,0) + 
 If(Q2ComboBox.Selected.Value <> "Yes",-10,0) + 
 If(Q3ComboBox.Selected.Value <> "Yes",-10,0) + 
 If(Q4ComboBox.Selected.Value <> "Yes",-10,0) + 
 If(Q5ComboBox.Selected.Value <> "Yes",-10,0) + 
 If(Q6ComboBox.Selected.Value <> "Yes",-10,0)
 )> 80,
 {Value: "Pass"},
 {Value: "Fail"}
)

DisplayMode