Update a choice column after 6 months

%3CLINGO-SUB%20id%3D%22lingo-sub-3080301%22%20slang%3D%22en-US%22%3EUpdate%20a%20choice%20column%20after%206%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3080301%22%20slang%3D%22en-US%22%3E%3CP%3EHey!%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20trying%20to%20build%20more%20automations%20into%20our%20lists%20and%20i'm%20stuck%20at%20the%20moment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECase%3A%3C%2FP%3E%3CP%3EWe%20have%20a%20list%20where%20we%20track%20how%20many%20have%20gotten%20access%20to%20our%20tools.%20This%20is%20tracked%20with%20the%20Submission%20(date%20column)%20and%20the%20Tool%20Access%20Status%20(Choice)%20-%20where%20we%20have%20Granted%2C%20Revoked%2C%20Review.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20we%20want%20is%20to%20be%20able%20to%20have%20a%20flow%20for%20spotting%20accesses%20to%20review%2C%20so%20per%20automation%2C%20we%20want%20it%20to%20run%20monthly%20and%20to%20change%20everyone%20that%20is%206%20months%20old%20from%20their%20submission%20date%20from%20granted%20to%20review.%20Is%20that%20possible%20and%20how%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20Recurrence%2C%20get%20items%20but%20get%20stuck%20on%20the%20compose%2C%20not%20sure%20how%20to%20best%20set%20that%20up%3F%3C%2FP%3E%3CP%3EAll%20the%20best%2C%3C%2FP%3E%3CP%3ETorbj%C3%B6rn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3080301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3080646%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20a%20choice%20column%20after%206%20months%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3080646%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1195256%22%20target%3D%22_blank%22%3E%40Torbjorn_Andersson%3C%2FA%3E%26nbsp%3Bwhat%20do%20you%20mean%20by%20user%20have%20got%20access%3F%20Is%20it%20that%20they%20have%20changed%20something%20or%20have%20uploaded%20someting%3F%20There's%20no%20way%20to%20get%20the%20details%20if%20they%20have%20just%20viewed%20something.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey! 

I'm trying to build more automations into our lists and i'm stuck at the moment.

 

Case:

We have a list where we track how many have gotten access to our tools. This is tracked with the Submission (date column) and the Tool Access Status (Choice) - where we have Granted, Revoked, Review.

 

What we want is to be able to have a flow for spotting accesses to review, so per automation, we want it to run monthly and to change everyone that is 6 months old from their submission date from granted to review. Is that possible and how?

 

I'm using Recurrence, get items but get stuck on the compose, not sure how to best set that up?

All the best,

Torbjörn

3 Replies

@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

Did you get an answer for how to do this? I'm trying to the same thing with my list - reset a column to "Needs Review" choice every month.