cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Calculations on Power app

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! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Calculations on Power app

Hi @karlosch :

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

3.JPG

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

 

3.JPG

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

 

DisplayMode.Disabled

 

27.gif

Best Regards,

Bof

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Calculations on Power app

Hi @karlosch :

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

3.JPG

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

 

3.JPG

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

 

DisplayMode.Disabled

 

27.gif

Best Regards,

Bof

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,856)