
Editing and approval in sharepoint list
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
