Exam PL-100 topic 3 question 2 discussion

Answer Should be "On Header Control" and If(SUM)

I think the first answer is On header control and for the second it would be the If(SUM... formula

Where should you apply logic to change the text? On the header control Which formula should you use? IF(SUM(RiskStatus1 value, RiskStatus2 value, RiskStatus3.value)<150, “”, “HIGH RISK”) The explanation is: You should apply the logic to change the text on the header control, because that is where the text is displayed. You can use the Text property of the header control to set the text based on a formula. You should use the IF function to check the condition of the sum of the risk status values. The SUM function can be used to add up the values of the slider input controls. If the sum is less than 150, you can display an empty string (“”) as the text. Otherwise, you can display “HIGH RISK” as the text. This way, the header control will only show “HIGH RISK” when the condition is met.

On the header Control If (Sum(...)) that's the correct answer, and it's tested

1. On the Header Control 2. If(Sum(),"","High Risk")

Reading more than once I guess it's on the HEADER (text property) and the IF(SUM, the condition is tricky because is sum<150, but if you pay attention to the formula the text "high risk" is on the ELSE part.. obviously a normal person will use the >= and the true part of the condition but hey, it's MS!

"On Header Control" If(Sum(...))

I tested with If(Sum(Slider1.Value + Slider2.Value) < 50; ""; "High RISK") on the text of a header for me it will be (1st) and (2nd)

Header Control If(Sum(RiskStatus1.Value+RiskStatus2.Value+RiskStatus3.Value)<150,"","HIGH RISK") Tested. working fine.

For the second one, the following answer is definately correct, If(Sum(RiskStatus1.Value,RiskStatus2.Value,RiskStatus3.Value) < 150,"","HIGH RISK"), although there is a few ways to achieve the same outcome, i.e., Context Variables, however, this would mean setting the text property to the variable.

Header Control If(Sum(RiskStatus1.Value+RiskStatus2.Value+RiskStatus3.Value)<150,"","HIGH RISK")

on the Header Control: If(Sum(Slider1.Value+Slider2.Value+Slider3.Value)>=150,"High Risk","") works, just tested in my power App. As soon you modify the slider value, the sum is updated and calculated on the fly.

Tested this in powerapps. Setting the text function on the header using IF(SUM most definitely works. There may be multiple ways to achieve this though, but this works.

I just tried and the answers are, 1. On the header control 2. the formula should be: If(Sum(Slider1.Value,Slider2.Value, Slider3.Value) > 150, "High Risk", "")

Let's assume you added formula to "on the header". Then your user moves e.g. slice1. Why should the formula "suddenly" calculate something? There is no trigger, no source of saying "do something, calculate something". The formula would just sit there because it never receives a request to process a change (od data entered by the user). Therefore, this cannot be the right answer. So 'on slicer' is correct.

Let's assume you added formula to "on header". Then your user moves e.g. slice1. Why should the formula "suddenly" calculate something. There is no trigger, no source of saying "do something, calculate osmething". The formula would jut sits there and never receives a request to process a change. Therefore, only a change in the slicer can trigger an action.

I'm not sure about second one. 1st: wrong formula 2nd: missing ", it must be "HIGH RISK" not HIGH RISK" 3rd: wrong, missing the first parameter - DataSource 4th: absolutely wrong