When a file is created update permissions

[Anonymous]

What I want to do is update the permissions on a file once it has been created in a SharePoint library.

My flow starts with 'When a file is created in a folder' and is followed by 'Get files (properties only)'.

I then used the actions 'Stop sharing an item or file' and 'Grant access to an item or a folder'.

The flow failed at 'Stop sharing an item or file', although it did remove the requested permissions on all the files in the folder.

So I guess I would need to create a filter under 'Get files..' on just the last created file. What formula would I need?

Also, is there no way I could just use the output from 'When a file is created in a folder' and skip out 'Get files'?

[v-alzhan-msft]

Hi @Anonymous ,

Please take a try to refer to screenshot below to create the flow:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-alzhan-msft for the suggestion but this threw up an error: Error details: Input parameter 'id' is required to be of type 'Integer/int64'. 

x-ms-file-id is not the actual ID but %252fShared%2bDocuments%252f plus the file name.

Under compose, ID was not one of the options.

I also need to get the Created by as an output so I can update their permissions.

Any other ideas?

[sudharsan1985 · Accepted solution]

Hi @Anonymous 

From the output of the 'When a file is created (properties only)' trigger action, you can use the 'ID' property (triggerOutputs()?['body/ID']) directly in the 'Stop sharing an item or a file' to stop sharing the permission for the file. Also, you can get the author information mentioned below by using the properties mentioned below.

"Claims": "i:0#.f|membership|username@o365practice.onmicrosoft.com",
    "DisplayName": "User name",
    "Email": "username@o365practice.onmicrosoft.com",
    "Picture": "/_layouts/15/UserPhoto.aspx?Size=L&AccountName=username@o365practice.onmicrosoft.com",
    "Department": null,
    "JobTitle": null

triggerOutputs()?['body/Author/Claims']
triggerOutputs()?['body/Author/DisplayName']
triggerOutputs()?['body/Author/Email']
triggerOutputs()?['body/Author/Picture']
triggerOutputs()?['body/Author/Department']
triggerOutputs()?['body/Author/JobTitle']

You can also directly choose the 'Author' info from the 'Dynamic Content' dialog shown below

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

[Anonymous]

Thank you @sudharsan1985 . I was using 'When a file is created in a folder' instead of the properties only one. 

That has worked now.