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

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,131)