Power Platform Community Forum Thread Details

Hi Power Apps/Power Automate gurus!

As someone who never used PA, I got an inquiry from the client if the following can be done:

There is a SharePoint list containing some data (important fields: "Data owner", "Data confidentiality")
Set the email that should be sent to "Data owner", based on the following logic: for "Data Confidentiality" A every 6 months, for "Data Confidentiality" B every 12 months
The "Data owner" should approve via this email the data deletion (separate workflow, not in the scope currently)
In case the "Data owner" hasn't approved, send a reminder email every 1 month later (until the "new" email of the next 6/12 month period is sent out)
The following attributes should be saved and updated in the SP list: "Last sent date"; "Last sent contact"; "Reviewed status current" (Y/N) -> set back to "NO" when an email from a new period is sent out; "Reviewed date current" -> set back to N/A when email from new period is sent out; "Reviewed status previous" (Y/N) -> contains the last valid state from previous period; "Reviewed date previous" -> contains the last date in which a review has been done
The email should only contain the "Approve" option - I've tried using the "Start and wait for an approval" action, but it offers only options that include "Reject" as well

Any suggestion would be highly appreciated.

Categories: