Odd behavior in Toggle control

(1) Share

Report

Posted on by tjestesjr

145

I have a toggle control that I am using to set an Is Active flag for a record in the database. I have a Power Automate Flow that calls a stored procedure that updates the value in my SQL Server DB. I have set the Default value of the Toggle to be the bit value in the database via a Lookup

LookUp('VC.BusinessEntities',BusinessEntityId=galBusinessEntity.Selected.BusinessEntityId).IsActive

This is all working well so far.

I have the OnChange property of the toggle set to run my flow:

UpdateContext(
    {
        OnChangeResult: VC_BusinessEntityIsActive.Run(
            galBusinessEntity.Selected.BusinessEntityId,
            tglIsActive_CarrierEdit_1.Value,
            User().FullName
        )
    }
);
 If(
        OnChangeResult.statuscode = "200",
        Notify(
            "Save Successful",
            NotificationType.Success,
            5000
        ),
        Notify(
            OnChangeResult.errormessage,
            NotificationType.Error,
            5000
        )
    );

Again, so far so good. The odd behavior is that the first time I access my edit screen where this control lives it fires the flow even though I haven't selected or changed the value of the control. Is this the intended behavior? How do I configure the control so that this doesn't happen?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Does the toggle have a default value?

Also, you could consider using the new toggle control which has an OnCheck and OnUncheck property.

Was this reply helpful? Yes No
Suggested answer

jpespena 335 on at

Like (1)

Report
Copy link

Link copied!
Hi,

I've experienced the same where accessing forms from View mode to Edit mode triggers the OnChange property of components like dropdown and toggles. If you want to keep your code in the OnChange property, you can add a validation that check if the value of the toggle is the same as the selected record, for example if you are coming from a gallery to the edit screen:

If( Gallery.Selected.ToggleFieldValue <> Self.Value, UpdateContext( { OnChangeResult: VC_BusinessEntityIsActive.Run( galBusinessEntity.Selected.BusinessEntityId, tglIsActive_CarrierEdit_1.Value, User().FullName ) } ); If( OnChangeResult.statuscode = "200", Notify( "Save Successful", NotificationType.Success, 5000 ), Notify( OnChangeResult.errormessage, NotificationType.Error, 5000 ) ); )

This code looks if the toggle value is not equal to the current value of the selected item in the gallery, then it perform the flow run.

If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

Was this reply helpful? Yes No
tjestesjr 145 on at

Like (0)

Report
Copy link

Link copied!
I moved the following code from the OnChange property to the OnCheck and OnUncheck properties. But I get the same result, which is that the flow is run automatically.

UpdateContext( { OnChangeResult: VC_BusinessEntityIsActive.Run( galBusinessEntity.Selected.BusinessEntityId, tglIsActive_CarrierEdit_1.Value, User().FullName ) } ); If( OnChangeResult.statuscode = "200", Notify( "Save Successful", NotificationType.Success, 5000 ), Notify( OnChangeResult.errormessage, NotificationType.Error, 5000 ) );

Was this reply helpful? Yes No
tjestesjr 145 on at

Like (1)

Report
Copy link

Link copied!

I implemented the If statement as @jpespena suggested and the toggle now behaves as expected.

Was this reply helpful? Yes No
jpespena 335 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If my post helped resolve your issue, please click Accept as Solution—this helps others find it more easily and marks the item as closed. If you found this or my previous reply helpful, a Like would also be appreciated!

Was this reply helpful? Yes No