Editing and approval in sharepoint list

MARTIN VALERO Carlota - Contractor 100 Reputation points
2023-10-06T11:26:58.2833333+00:00

Good morning,

I have a Microsoft lists in which during the first 8 days of the month, every month a person has to enter a value:

Month Current Value

January 89

February 78

March 98

April 78

May

  • I would like to send a monthly reminder on the 1st of each month to a manager to enter the number in the Current Value column every month, that as soon as this data is entered, a request for approval is created to another person (the manager of the list) and, if it is not approved, the number of the value entered is deleted and another reminder is sent saying that the request has been rejected and the data must be re-entered in the Current Value column. *If a flow is performed that is when an item is created or updated; Initiate and wait for an approval; Condition; result = Approve; If not; update item: Current Value = null; It enters the flow in an infinite loop and sends a thousand approval requests per minute (I want to avoid this).
  • I would also like the manager to only be able to edit the value column, only have edit permissions for the first 8 days of each month and then not be able to edit the list again until the next month from day 1 to day 8 of that month; but if the request is rejected, be able to edit to add the data in the Current Value column until day 14 of each month.

-On the other hand (if possible) you can edit only the Current Value column and the row of the corresponding month (I don't know if this is possible).

For example:

On May 1st an email is sent to a manager named Mario who says that he has from day 1 to day 8 to add his data to the Current Value column in the row of the month of May.

Once the data has been added, a request for approval is sent to the list manager named Sonia, and she rejects the request, so the number that Mario has added to the Current Value is deleted (but not the row, only that number).

After rejecting the request, another email is sent to Mario telling him that his data has been rejected and that he must add the data again, but he has until the 14th.

Once the 14th day has passed Mario will no longer have editing permissions on the list until next month.

Month Current Value

January 89

February 78

March 98

April 78

May 93

How could I do this with a power automate flow?

Thank you very much for your help

Microsoft 365 and Office | SharePoint Server | For business
Microsoft 365 and Office | SharePoint | Development
Microsoft 365 and Office | SharePoint | For business | Windows
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.