Skip to main content
Community site session details

Community site session details

Session Id : eu8SpMbdmdD+Lqc+ROVcv2
Power Apps - Building Power Apps
Unanswered

Set datacardvalue1 to Pass/Fail depending on status of other datacardvalues

Like (0) ShareShare
ReportReport
Posted on 4 Dec 2023 21:13:23 by 55

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

FranciscoSaba_0-1701722443276.png

 


I'm trying to change the Status Datacard value to Pass or Fail depending if all other toggle Datacard values:

FranciscoSaba_1-1701722443090.png

 

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"}
)

 

 

 

FranciscoSaba_2-1701722443154.png


Let me know if anyone can help! 

@MM@v-yueyun-msft , @WarrenBelz@M_Ali_SZ365@M_Ali_SZ36@LaurensM@SpongYe 

  • mmbr1606 Profile Picture
    13,489 Super User 2025 Season 2 on 04 Dec 2023 at 21:35:08
    Re: Set datacardvalue1 to Pass/Fail depending on status of other datacardvalues

    Wrong reply, sry

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473