Toggle, Condition, Patch not Working Together

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a Toggle that designates 'Compliance', 'Noncompliance' based on a condition.

The Toggle has Patch functions back to an SP List:

OnCheck:

Patch(
MemberList,
LookUp(MemberList,FullNm=ECMemberSearchDD.Selected.FullNm),
{
ComplianceStatus: "Compliant"
}
);

OnUnCheck:

Patch(
MemberList,
LookUp(MemberList,FullNm=ECMemberSearchDD.Selected.FullNm),
{
ComplianceStatus: "Noncompliant"
}
);

My issue is the Toggle doesn't seem to be resetting/refreshing/updating the data when the Member's name is changed (by Dropdown). If one Member is Noncompliant, and the next Member is Noncompliant no Patch is taking place, even though it may be an overwrite of the existing 'Noncompliant' status. If the name change is from 'Compliant' to 'Noncompliant' or reverse, the Patches work fine.

This sounds contrary; however the issue further is the 'ComplianceStatus' is a new column in the SP List. Consequently, the column is empty for most of the 800 Members. When I go through multiple names in the app that are all 'Noncompliant' nothing happens. Is there a way to reset/refresh the Toggle when a new name is chosen in the Dropdown so that regardless of the content in the SP ComplianceStatus list column a Patch takes place, even if an overwrite?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

A toggle can only have a value of true or false. It takes a little coding to set it's default value and to use its value to enter text into a column. So for setting the default for an item in a gallery

If(ThisItem.compliancestatus = "Compliant",true,false)

Likewise in an edit form, the Update property of the card for compliancestatus containing a toggle would be:

If(Toggle1.Value=true,"Compliant","NonCompliant")

In a Patch function,

Patch( MemberList, LookUp(MemberList,FullNm=ECMemberSearchDD.Selected.FullNm), { ComplianceStatus: If(Toggle1.Value = true,"Compliant") } )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.

Can you tell me why it is whenever I manually change the Toggle my Dropdown and Gallery default to the default name / based on location as determined by a Dropdown in a previous screen?

When I get to the screen I see the names I should see in the combbox, based on the Location. However, once I switch names and then manually change the Toggle the entire thing resets, as if my toggle control has a reset screen to default condition; which it does not. Thoughts?

Also, I'm using the OnCheck, OnUnCheck for my Patch statements.

Should I have one statement in the OnChange? Could that be the problem?

I'm really perplexed. I don't under why a change toggle should reset the controls and data.