
I have a power apps created. I have linked it to a sharepoint list. I have created a form which is based on that list. This form is called form1. Now, I've added a tick button on the main page, what I want to happen is this, when the user presses this checkbox, it archives the data from from 1 into a different list (I have also added this as a data table) and it then removes this item from the first list?
The way the app works at the moment is, the user can create an item, then can go in and add values and then re-edit them at another time. But then once they have finished with it, I want to be able to archive it into a different list. Now What I could have done is added a separate column in my first list which was "Complete" and when the user pressed this checkbox it would write complete to the sharepoint list and I can then filter the ones without "Complete" in my list. However I dont know how to achieve this either. If someone could talk me through the step for either way around this problem I'd be very appreciative.
Thanks
Hi @ciaranc
You can add the condition to the Filter of the gallery
Filter(Source,(previous conditions) && "Complete"=false)
Then you could create an automated FLOW that starts once or more times a day, check all items in the Sharepoint List with the Complete = true (it can be done directly in the filter query of the GET ITEMS), you can create the item in the Archive Sharepoint List and then delete the item in the original list.
Move from one Sharepoint List to another is not possible (as far as I read until now)