You’re offline. This is a read only version of the page.
74
Hello all,
I have this list on the sharepoint, which is editable by all users, and everytime the column Status reaches "Solved", I want sharepoint to copy that item to another Sharepoint list, which is not even visible to all users, thus making it not editable/visible.
Right now, I'm using the @TheRobRush guide from
But I have the issue with updating the item only when the columns Status reaches "Solved", as aforementioned. Also, I need the item to be copied only once to avoid people editing the remaining columns and then editing the Status to "Solved" again in order to modify the whole record.
Thanks in advance
The best way to do this would be to setup a flow that will run on the first list when an item is created or modified. Use a trigger condition that only triggers when the status reaches "Solved". Have the flow copy the item to the second list and either delete it from the first list or set item level permissions on it so that it is now readonly. The flow can be created to run in the context of the maker. Taht way they are the only one who needs access to the second list. There is no way to do what you want with Power Apps alone.
Share
Report
All responses (
Answers (
