Odd behavior in Toggle control

(1) Share

Report

Posted on by tjestesjr

130

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:

General Questions

All responses (5)

Answers (0)

jpespena 335 on at

Like (0)

Report

Odd behavior in Toggle control

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!
tjestesjr 130 on at

Like (1)

Report

Odd behavior in Toggle control

I implemented the If statement as @jpespena suggested and the toggle now behaves as expected.
tjestesjr 130 on at

Like (0)

Report
Odd behavior in Toggle control

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 ) );
Suggested answer

jpespena 335 on at

Like (1)

Report
Odd behavior in Toggle control

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!
ronaldwalcott 1,501 on at

Like (0)

Report

Odd behavior in Toggle control

Does the toggle have a default value?

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