Help with permissions to edit a list row in Sharepoint

(0) Share

Report

Posted on by CarlotitaMrt

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.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CarlotitaMrt ,

Although I don't think this is feasible in PowerApps, you can ask a question in the SharePoint community to reconfirm.

Best regards,
CarlotitaMrt 43 on at

Like
a
(0)

Report
Copy link

Link copied!

in Sharepoint I have been told that it can be done through a Power Automate flow, that's why I was asking here, if there is any option to give editing permissions in the current month's row and that the editing permissions of the previous month are blocked.
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CarlotitaMrt ,

With PowerAutomate, I imagine that every day you will need to iterate all items of the list to stop sharing, and then get items based on a condition (which I really didn't understand), grant access to each item for a person or everyone (I don't know). Flow should be able to be generated, but if the list is large, it will consume a lot of resources and cost a lot of time to run.

Best regards,
CarlotitaMrt 43 on at

Like
a
(0)

Report
Copy link

Link copied!

What I want, is that as each month a new value is added to the Current Value column, then from day 1 to day 8 of that month, a selected person can have permission to edit that row corresponding to that month, but the previous months can not modify anything and, after day 8, no longer have permission to edit anything.