Power Platform Community Forum Thread Details

Hi there

Hope you are all well 😊

I'm new to Power Automate and wondered if someone can give me a few pointers.

I have a Software Asset Register that I have put together in Excel and have uploaded into a SharePoint list i.e.,

Title PurchaseDate ReviewDate ReviewSchedule

7-zip 03/08/2023 03/08/2024 1 year

Audacity 03/08/2023 03/08/2024 1 year

I have created a Flow with a reminder email to be sent to a shared inbox 14 days before the ReviewDate, so far so good. What I would like to do thereafter is create an Approval to give the option to either reject the software or approve. If approved, then the date at which the software is reviewed becomes the new date from which the 1 year is calculated again. Basically, I want to be able review pieces of software every year (in or around) and a new 12 months added to the cycle once reviewed - not sure if this is the best way to address it, too so any advice would be gratefully received!

Thank you so much

Categories:

General topics

Good Afternoon!

I'll split this response into two parts since I'm unsure about what part of your question is.

The part I am confused about is:

How do you plan on updating the item once you approve or reject it? Did you intend on using some sort of connector to send back an update automatically (and if so, which connector)? Or, were you asking for what connector would be best to send this update? If the latter is the case, I recommend either a 'Send Email With Options' or 'Post A Choice of Options as the Flow Bot to a User' which use Outlook and Teams respectively.

To answer the part about the 'and a[dd] new 12 months added to the cycle once reviewed' that can be simply done using a number of methods:

If you intend to do a year from when the person responded to the Email, I usually use something along this lines of this: