Hello,
I have a Room Check app created, and I've set an EditForm connected to a SharePoint list, each Choice column has toggle "Pass", "Fail", "N/A" under the device/area the user is checking. Here's is a screenshot for reference:
Pass toggle = device/area passed
Fail toggle = device/area failed
N/A checkbox = if device/area is non-applicable
I'm trying to change the Status Datacard value to Pass or Fail depending if all other toggle Datacard values:
Currently, the following formula is 50% working. If all toggle datacardvalues are set to "Fail" - the Status Datacard will set to Fail, but if one or more toggle datacard value is set to "Pass", it will reflect "Pass". I would like the Status datacard value to reflect "Fail" until all toggle datacard values reflect Pass or N/A. As of right now, the N/A checkbox is also causing issues with the Status datacard, if all marked "Pass" and one datacard is marked N/A, then the Status datacard sets to "Fail", I noticed that it does not happen when I added CheckboxPower.Value,{Value: "Pass"} after the first {Value: "Pass"} bracket, the Power "N/A" checkbox did exactly what I wanted it to do, but when trying to add the rest of checkbox"datacard"value to the formula, it did not accept it with && or || symbols, the formula I'm using is below:
If(
vCableTV.Value &&
vPower.Value &&
vCall.Value &&
vLocalPresentation.Value &&
vOtherUCPlatforms.Value &&
vContentSharing.Value &&
vCamera.Value &&
vSpeakers.Value &&
vMics.Value &&
vVideoConferencing.Value &&
vDisplays.Value &&
vInRoomTouchPanel.Value &&
vSchedulingPanel_Toggle.Value,
{Value: "Pass"},
CheckboxPower.Value,{Value: "Pass"},
{Value: "Fail"}
)
Let me know if anyone can help!
@MM, @v-yueyun-msft , @WarrenBelz, @M_Ali_SZ365, @M_Ali_SZ36, @LaurensM, @SpongYe
Wrong reply, sry
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473