I have built a Employee Time Entry app which as the user is entering each day it is added to a collection and they have a screen where they can review these entries in a gallery and when happy they submit it to a SharePoint list. Some of the feedback I have been given is the users want to be able to enter a day and have the ability to exit the app then go in again next day to enter the following one but want to be able to see the previous day(s) too all before actually submitting anything to the SharePoint list.
From what I gather so far I need to set up another (in progress) SharePoint list with the same columns so they can save each day as they go but when they come back into the app need it to populate the collection with the previous data. I think I need to have some formula in the OnStart property of APP but I'm unsure the correct formula to set this up to do this. How can I do this? They need to be able to add to this without wiping any existing data then once their full week is in there they can submit to the final SharePoint list. they also need to only see their own data.
I can have an automation which archives the in progress data once the data has been submitted to the final list.
How to prevent a collection being wiped when exiting the app to continue progress
@Hack-7
I need to have separate list as the information is only to be submitted to the main list once employees are happy with it and finally submit there but the issue that was raised was that they want to be able to add a day, and log back into the app to continue progress and only submit at the end of the week.
How to prevent a collection being wiped when exiting the app to continue progress
Hi @WarrenBelz
I have added this in to the OnStart property for APP but when I add a record into the app first post it to my InProgress list, exit the app and then when I go back in the record that was posted doesn't show in the gallery linked to the collection. The record is showing in my list but it just doesn't seem to pull back to the collection.
I have some other formula already on the OnStart property of the app to add side menu, variable for the user and collection for working with time in the app and finally this new one I need at the bottom. Do I need to structure my full formula differently to get this to work? Formula below:
How to prevent a collection being wiped when exiting the app to continue progress
As Warren said you will need to collect the data from a list, but I would not complicate things with having a 2nd - In progress list. Just add a new column which will track Status.
Then you will be able to filter by Employee and Status to see 'In Progress' or 'Completed'. Having 2 list will complicate the logic and then you will need to start using AddColumns(), ShowColumns() and LookUp() in the collection.
You are on the right track - you simply need to collect the data from your list
ClearCollect(
YourCollection,
YourListName
)
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.
28
Share
Report
All responses (
Answers (
