web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Granting SharePoint do...
Power Automate
Unanswered

Granting SharePoint document editing permissions with a link

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

 

Here's the situation:

 

I have a SharePoint list that contains links to documents in a protected SharePoint folder (in the "Link to copy" column):

 

sharing link.PNG

I have a flow set up that automatically sends the link via email to the business partner so they can review and approve the copy.

 

However, not all business partners have access to the protected SharePoint folder. Is there a way/flow to grant them automatic editing access to the document when they receive the link via email? I'd prefer if they didn't have access to the entire folder (some content is confidential), but rather just the document for which they receive the link.

 

Please let me know if I was not clear enough.

 

Thank you!!

Categories:
I have the same question (0)
  • vivekpande18 Profile Picture
    894 Super User 2024 Season 1 on at

    Hi @Anonymous ,

     

    Probably you can do that with the use of a file URL. Please find below the steps

    You can include the below steps in your existing flow.

     

    1- To provide unique permissions to documents, you require a file server relative URL.

    2- The server relative URL will get from the document link stored in the column.

    3- Once you retrieve the server relative URL of the file, break the role inheritance to add new permissions

    4- Get the principal id of the users/group to which you want to add permission.

     

    Flow steps:

    1 - Retrieve server relative URL.

    vivekpande18_0-1652264209744.png

    Value : /sites/ {{expresssion}}

    {{expresssion}} =  split('value of your document link column ','sites')[1]

     

    2- Break role inheritance of that document to provide permissions

    vivekpande18_2-1652264372044.png

    Uri : /_api/web/GetFileByServerRelativeUrl('@{variables('Server Relative Url')}')/ListItemAllFields/breakroleinheritance(copyRoleAssignments=false,clearSubscopes=true)

     

    Note : This will remove the inherit permission of your document, which is delegated from parent.

               If your file already have unique permission, then it will do nothing and simply ignore this action.

     

    3- You need to get the principal id of all the users, to whom you want to add permissions. After that use below action to provide  permission.

     

    vivekpande18_3-1652264639660.png

    In above case I have hardcoded the principalid = 45 , you need to get dynamically by passing user email or name.

     

    Role definition :

    vivekpande18_4-1652264697349.png

     

    Thanks,

    Vivek

     

    If this post helps answer your question, please click on "Accept as solution" to help other members find it more quickly.

    If you thought this post was helpful, please give it a thumbs ups

  • Community Power Platform Member Profile Picture
    on at

    Hi Vivek,

     

    Thanks for your response. I tried what you explained, but I get an error: 

     

    InvalidTemplate. Unable to process template language expressions in action 'Server_Relative_Url' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#split for usage details.'.

     

    Am I doing something wrong here?

     

    Thanks!

  • vivekpande18 Profile Picture
    894 Super User 2024 Season 1 on at

    Hi @Anonymous , 

    It seems like you are providing some null input. 

    At which action you got this error. 

    Can you paste your flow here. It will be easier to analyse 

     

     

    Thanks

    Vivek

  • Community Power Platform Member Profile Picture
    on at

    Sure can! Here is what I've got:

     

    brihegwun_0-1652389069982.png

    expression: 

    split(triggerOutputs()?['body/Linktocopyorcommsplan'],'sites')[1]
     
    brihegwun_1-1652389161981.png

     

    And from here, an automated email is sent if a condition is met.

     

    I appreciate your help! Please let me know if I missed providing anything.

     

    Best,


    B

  • vivekpande18 Profile Picture
    894 Super User 2024 Season 1 on at

    Hi @Anonymous , 

     

    Can you please check the output of triggerOutputs()?['body/Linktocopyorcommsplan']  this colum. 

    Is it comming null? 

     

    Thanks, 

    Vivek

  • Community Power Platform Member Profile Picture
    on at

    Hi @vivekpande18 ,

     

    Because the flow keeps failing at this point, this is all I see for outputs:

    brihegwun_1-1652708707716.png

     

    Here is a screenshot of the peek code, in case that is helpful:

    brihegwun_0-1652708483280.png

     

    Thank you!

     

    Bri

  • vivekpande18 Profile Picture
    894 Super User 2024 Season 1 on at

    Hi @Anonymous , 

     

    I want you to check the output of the Linktocopyorcommsplan column in separate variable. 

     You will get the above column in dynamic content. 

    This might be empty column and split function doesn't work on split function. 

     

    Can you check that

     Thanks

     

  • Community Power Platform Member Profile Picture
    on at

    Hi @vivekpande18 ,

     

    Thanks for explaining. I apologize; I was looking at the wrong test.

     

    It actually looks as though it's getting hung up on the "break inheritance" step: 

    brihegwun_0-1652723166928.png

     

    It just keeps retrying on this step and failing.

     

    Thank you!

     

    Bri

  • vivekpande18 Profile Picture
    894 Super User 2024 Season 1 on at

    Hi @Anonymous , 

     

    Can you paste the server relative url which you are getting? 

     

    Thank

    Vivek

  • Community Power Platform Member Profile Picture
    on at

    @vivekpande18 ,

     

    Yes, here is the value from the Server Relative URL: 

    /sites//StratCommsTeam/_layouts/15/Doc.aspx?sourcedoc=%7BC50C2AB1-5F2C-4456-BD07-50498A137791%7D&file=4.6.2022_E_ERBUpdates_ERBEmployees.docx&action=default&mobileredirect=true 

     

    Thank you,

     

    B

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard