Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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 @hari3 ,

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 User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (52,219)