web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Save items in collecti...
Power Apps
Answered

Save items in collection as a draft after exiting app, and clear the collection after hitting submit once a month

(0) ShareShare
ReportReport
Posted on by 242

Hi,

 

I have made an expenseapp. There is a button to create a new expense.

It creates a collection with several columns. People use it once a month and sometimes have over more than 15 items.


They would like to be able to daily put in their expenses, which the app saves but not sends.
And the once a month, click on submit so send them all.


So, i added an new column to the collection when a new expense is created called Status.

It sets the item on draft. When they save the item it, creates a new line and also with the status draft.

 

But now i don't now what to do. I want the items in the collections to be saved after exiting the app and only disappear when they hit the submitbutton once a month. So they can enter items the whole month.

 

Is there a way to achieve this?

Categories:
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Hi @Mirtemir 

    Collections exist only in memory and are deleted once you close the app.  There are two ways to save them.  The easiest and most straightforward way is to create a connector to a table stored in Excel On Line, a list in SharePoint, a table in SQL or an entity in CDS.  Each of these connectors will have a field that matches one of the columns in your collection and save them there. 

    The other way is to use the SaveData() and LoadData() function.  ref https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-savedata-loaddata .  There are limitations to the latter way but there have been recent improvements.  https://powerapps.microsoft.com/en-us/blog/savedata-and-loaddata-unleashed/ 

  • WarrenBelz Profile Picture
    156,528 Most Valuable Professional on at

    @Mirtemir ,

    Agree with @Drrickryp except LoadData and SaveData only work on mobile devices (which is great if that is what your users are operating on).

    The other thing you would need to save if not on mobile devices would be the User's email or name, you could filter the (I suggest SharePoint) list for just their records and then after upload either delete the records or mark them as uploaded.

  • Mirtemir Profile Picture
    242 on at

    Ok, thank's for the ideas. I think i will just leave it the way it is for now. The don't use the mobile app.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 409 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 252 Most Valuable Professional

Last 30 days Overall leaderboard