Sep 21 2020 09:48 AM
I have built a Power Automate workflow on a list for sequential approval of an Excel document uploaded to a Document Library. The approvers receive an approval task with a link to the uploaded Excel, and should be able to view but not edit the document, so that they can review and then approve or reject.
I instructed the users who upload the Excel and initiate the workflow to capture the Excel link by:
However, they found that doing this does not prevent editing of the Excel. I have run tests to confirm, and found that the only condition in which folks cannot edit the Excel is if they have Read permissions - if the above process is followed, using the resulting link, anyone with Contribute permissions or higher can edit the Excel.
Is this correct functionality? Specifying that folks cannot edit a document but they can in fact edit the document seems very misleading and I am confused as to why this is happening.
Sep 21 2020 01:24 PM
Sep 21 2020 02:50 PM - edited Sep 21 2020 04:55 PM
@Chris Webb - thanks for your response. I have also spoken with MS Support and they have confirmed that only folks with Read access will be unable to edit a shared document, even if Allowed Editing is unchecked - folks with Contribute access or higher will be able to edit.