How to reset form fields when the toggle is on

[orin1]

I want to create a form for lunch orders with toggle options (off for sandwich on for salad)

when the toggle is on\off a specific field in the SharePoint form need to get invisible (done it) and blanck\reset (didn't manage to do it).

any ideas for the easiest way of doing it?

[yashag2255]

Hi @orin1 

Can you try to update the expression on "OnCheck" property of the toggle control to:

Reset(Control1);Reset(Control2);Reset(Control3);

Here, you need to replace Control1,Control2,Control3 with the actual names of controls. In case you have more than three controls, you can add Reset() function for all controls.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[RandyHayes]

@orin1 

Not sure which column in your record you are referring to, but I am assuming it to be a text field and am assuming you have this in an EditForm.

In which case, you can use a formula similar to this in your Default property:

If(yourToggle.Value, Blank(), ThisItem.ColumnName)

Replace yourToggle with the name of your toggle and ColumnName with the name of your column you want the value from.

I hope this is helpful for you.

[orin1]

I`ve tried already:

oncheck= (DataSalad.Visible=true And DataBread.Visible=false And DataSize.Visible=false And Datafill.Visible=false) And (Reset(DataBread) And Reset(Datafill) And Reset(DataSize))

But it`s doing nothing (although the expression is correct)

I used a rel eventually for the visibility but couldn't find a solution for the reset

[RandyHayes]

@orin1 

Your expression is far from correct I'm sorry to say.  That expression will do pretty much what you saw.

In PowerApps, you cannot set properties like that.  You need your properties to subscribe to other variables, actions or formula logic.

So, for your DataSalad Visible property if you want that visible when your toggle is set to Salad, you will put the formula:  

yourToggleName.Value

This will equate to "true" when your toggle is true ("Salad") and thus your DataSalad card will be visible.

Likewise, in your DataBread Visible property, you will put this formula:

!yourToggleName.Value

This will equate to "false" (in this case using the Not (!) operator to negate the true) when your toggle is set to Salad and thus not visible, but visible when set to Sandwich.

This formula would also be used on your DataSize and Datafill Visible properties.

But all of the above deals with the Visible aspects of your form - I thought you mentioned you already had that complete?

As for the resetting of the values, again the formula I gave you for the Default property of your controls would be used to blank them out based on your Toggle.  You need not put anything in OnCheck.

[orin1]

I changed it

As for the visibility I used a simple rule.

As for the reset, I tried using: If(Toggle3.Value, Blank(), datafill.ColumnName)

but, datafill is a Combobox, and I don`t have a ColumnName.

[orin1 · Accepted solution]

I've found a solution,

For the reset, I`ve set in the toggle:

on check= Set(myvar,[])

on uncheck= Set(myvar2,[])

and set the combobox related to the on check, DefaultSelectedItems= myvar

and set the combobox related to the on uncheck, DefaultSelectedItems= myvar2

[RandyHayes]

@orin1 

Ah I see now - my mistake for not looking at the picture a little closer.  You have ComboBoxes on the screen.

For those, simply set the DefaultSelectedItems property to:

If(Toggle3.Value, Blank(), Parent.Default)

This is assuming you actually want any underlying value to actually retain their values when you edit the record.

Always prefer a way to do things without variables if you can.