Forum Discussion
Update a choice column after 6 months
Torbjorn_Andersson what do you mean by user have got access? Is it that they have changed something or have uploaded someting? There's no way to get the details if they have just viewed something.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Hey RobElliott
So our users don't interact with our list, it's pretty much me who changes the entries. They submit a form letting me know that they are starting and what date they do so.
From that i change the column called "Tool Access Status" where i can keep track of who i've granted access to our tools for.
I need to review that they still need access every 6th month and these i manually change to "Review". This i do by checking the date column for when they submitted their form and if it's 6+ months i do the change before i start the process of revoking access to people thus changing the column again to "revoked".
So that's what i want to automate, so that every month or so the flow goes through my list and everyone with a submit date that is 6 months or older -> change them to review.
I hope that clarified my case a bit.
All the best,
Torbjörn
