Help with editing permissions for a sharepoint column

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.

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.