Announcements
In aim to make this app more user friendly I wish to have a toggle that when checked returns "Positive" and when unchecked returns "Negative" when form is submitted. Before I built this as a drop down list.
How do I link this toggle to the column in SharePoint list to return Positive or Negative dependent on how the toggle is selected? I have already changes FalseText to Negative and TrueText to Positive.
Thank you in advance
@DIYworkitoutMan
Consider changing the formula in your Update property (assuming from the look of your picture that this is in a Form), to the following:
If(yourToggleControlNameHere.Value, "Positive", "Negative")
I hope this is helpful for you.
@RandyHayes
Thank you for your quick response. I may sound dim here but I cannot find the Update property for the toggle anywhere. Am I looking in the right place?
Please confirm that your controls are in a Form, or better yet, how are you submitting the data in the screen to your datasource?
I inserted a toggle to the screen to replace a dropdown that was in the form. I did the same for the radion's. My data source is a SharePoint list. This is the code I am using on a submit button,
Patch('Safety Observations', Defaults('Safety Observations'), Form1.Updates, Form3.Updates);
Notify("Observation Saved",NotificationType.Success);
ResetForm(Form1); ResetForm(Form2); ResetForm(Form3);
Navigate(BrowseScreen1);
You should not be using a Patch function on forms! SubmitForm is what you need. If you are splitting a form to multiple screens then I would advise doing that in a way that does NOT break the function of the Form. Take a look at this video on that process.
Your formula makes assumptions that it should not - particularly, you are Patching and then notifying that it was a success...what if it was not?? The form provides the OnSuccess and OnFailure actions to account for those conditions properly. But, if you use Patch on the Updates of the forms, then you lose all of that functionality.
Now, for the Toggle, it will be in a datacard in your form. The datacard has an Update property which is where you would use the formula that I originally provided.
@RandyHayes Thank you for your support. First ever app and I definitely was making this far too difficult for my own good. Works like a charm.
Excellent! Yes...always keep it simple in PowerApps and your experience will be much better. Keep in mind that PowerApps is a design platform that revolves around the principles of Excel. Think Excel all the time with formulas and referencing other cells - in PowerApps case, referencing controls.
If you're good now at this point, please go back and check the post that helped resolve your problem as "accept solution" to close this out and help others fine the similar answer if they have the same problems. Thanks 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 638
Haque 317
WarrenBelz 315 Most Valuable Professional
