Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to save, delete and reload the data again from sharepoint list to powerapp

I'm trying to build a powerapp where one of the functionality is for the user to enter something in a text field and if they do so, a toggle switch will be turned on. However, I need it so that once a user enters something in the input field, it gets stored there even upon closing the powerapp. I've created a sharepoint list to try and save and reload the data but don't know if this is the way to go?

Also if the user clears the input field I need the powerapp to stay updated accordingly. Any help is appreciated.



Hi @Anonymous ,

If you require a data source that helps you persist the state of a field outside of the app session, then a list is probably the way to go, unless your users are exclusively using mobile devices in which case you can use the offline capability to store persistent data between sessions.

Either way, you probably need to use the OnChange: property of the text input to save the data immediately to the source.

You would do this using Patch()  or SubmitForm() depending on how you're presenting the input text field to the user...

If the user deletes the data in a field, you may need to enable Formula Level Error Management under Settings for your app, (you can find it under experimental features) in order to write back a null/Blank value to SharePoint - otherwise PowerApps may just leave the field as it was without updating it.

Hope this helps,


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,360)