Help with editing permissions for a sharepoint column

Question

I need help with editing permissions and access to a sharepoint list.

I have a list that is:

Mes-Año Valor Actual

8/1/2023 34

9/1/2023 56

10/1/2023 34

11/1/2023

12/1/2023

-Then, each month (the one we are in), a person has to add a number to the numeric column Valor Actual; so I would like that person who has edit permissions during the first 8 days of the month, can only edit the Valor Actual column and can only edit the month we are in; I mean, Now in November (11/1/2023), can only edit in the row of the month of November and can only edit the data of the Valor Actual column, but the rest of columns, and the rest of previous months can not edit, change or modify anything.

For example December (12/1/2023) you can only edit during the first 8 days of the month the Valor Actual column of that month, but the previous data added, you can not modify anything.

-I would also like that in the Valor Actual column, only data between 0 and 100 can be added, no negative numbers, nor any number greater than 100.

I do not know if it would be possible but thank you very much for everything.

Answer 1

Hi @MARTIN VALERO Carlota - Contractor,

Thank you for posting in this community.

Unfortunately, we can't set it to modify only a certain column of values in a certain row. However, we can create a timed task on the 1st of each month that will give editing privileges to the user for the row that will be modified in that month. And remove the permission on the 9th of each month.

Preparation:

The date is recorded as a Date and Time type column. And numeric column Valor Actual column is a numeric type column and set the maximum and minimum values.

Power Automate flow at the beginning of the month:

1.Create a Scheduled cloud flow. Implemented on a monthly basis.

2.Find the id of the item to be modified based on the value in the date column by using Filter Query. Please replace your date column name.

Your date column name eq 'formatDateTime (convertFromUtc(utcNow(), 'Central Standard Time' ),'MM/dd/yyyy')'

3.Use the Grant access to an item or a folder step to grant editing privileges to the appropriate people.

Power Automate flow on the 9th of each month：

1.Create a Scheduled cloud flow. Executed on the 9th of every month.

2.Find the id of the item to be modified based on the value in the date column by using Filter Query. Please replace your date column name.

Your date column name eq 'formatDateTime (convertFromUtc(addDays(utcNow(),-8), 'Central Standard Time' ),'MM/dd/yyyy')'

3.Use Stop Sharing an item or file to stop editing permission.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @MARTIN VALERO Carlota - Contractor,

Okay, let me explain to you the conditions of these two filters.

utcNow() is to get the current timestamp, convertFromUtc will convert this timestamp from the source time zone to

Central Standard Time, formatDateTime is to change the date display style to month/day/year and addDays(utcNow(),-8) is to subtract eight days from the current date.

Let's take an example. We need to open up user editing rights on the line dated 11/01/2023 from November 1st to November 8th. So, this condition:

Your date column name eq 'formatDateTime (convertFromUtc(utcNow(), 'Central Standard Time' ),'MM/dd/yyyy')'

is to get the id of the row with the date 11/01/2023. because the date the stream was started is the same value as the date column, both are 11/01/2023.

Next, on 11/09/2023 we need to stop the user's editing permission. The second flow is running on 11/09/2023, so we need to get 11/01/2023 by subtracting 8 days from the current date(11/09/2023), which is the same value as the date column of the row we want to stop edit permission on. So, this filter:

Your date column name eq 'formatDateTime (convertFromUtc(addDays(utcNow(),-8), 'Central Standard Time' ),'MM/dd/yyyy')'

is also get the id of the row with the date 11/01/2023.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.