Use a toggle to change a field

[NigWatson]

Hi,

I want to add a Toggle to change a field from Y to N.

I'm new to PowerApps need some help filling all the necessary function fields

[AKotb]

Hi,

do you mean changing the content of a Label from Y to N ?

in that case you can do that easily by changing the text rule of the label to something like this

If (Toggle1.Value, "Y", "N")

where Toggle1 is the name of the toggle control

[NigWatson]

No,

 I want to use the toggle to change a data field in the data source from N to Y.

Thanks

[Drrickryp]

Hi @NigWatson,

Set Toggle properties

OnCheck - Patch(datasource,baserecord,{datafield:”Y”})

OnUncheck - Patch(datasource,baserecord,{datafield:”N”})

baserecord would be be something like LookUp(datasource, ID=Gallery1.Selected.ID) or 

LookUp(datasource, ID=ThisItem.ID) if the toggle was inside a gallery.

[NigWatson]

Thanks Drrickryp,

But I don't understand baserecord

Could you please explain  LookUp(datasource, ID=Gallery1.Selected.ID) ?

[Drrickryp]

The patch function consists of three components: the datasource being patched,  the base record being edited and the item being changed. It would be helpful if you could post a screenshot of the screen where you are placing the toggle so I could better explain it to you.  If you want to visualize it imagine a spreadsheet that contains a Table, thats the datasource.  The row inside of the table is the base record and the field in that row is the datafield.  Please watch the You Tube about the Patch function to understand how it works. 

https://www.youtube.com/watch?v=gX5q_V3U8-s 

In your case, I want to use the toggle to trigger the Patch function and make the change you want in your datasource.  

[NigWatson]

Hi Drrickryp,

Here are shots of the App's edit screen and it's data source:

[Drrickryp]

Ok, This looks like it could be from an app developed from an Excel spreadsheet, Is that correct?  If  you are using an edit form, then you won't need to use the Patch function.  Please post a screenshot where you mouse over the red x so that I could see the error message you are getting.

[NigWatson]

Yes, that's correct the app was generated from a speadsheet.

Here's the error message.

[Drrickryp]

Ok get out of preview mode by hitting f5.  Then click on the card containing the toggle but not the toggle itself.  Open the dropdown box in the upper left hand side of the screen and find the Update property.  Please let me know what it says.