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.