Unanswered

How to know the groups or people who can edit a file in Automate

(0) Share

Report

Posted on by SDX1

Hi, I was working on a project to filter files that contain specific keywords, e.g "confidential", in file names or file contents and return their properties back, including Title, Path, Aurthor.... So far, I have successfully achieved these (with the flow below).

"Send an HTTP request to SharePoint" code view (I am not showing the site/library address here):

"type": "OpenApiConnection",

"inputs": {

"parameters": {

"dataset": <my site>,

"parameters/method": "GET",

"parameters/uri": "_api/search/query?querytext='%22confidential%22 path:<my site's library>'",

"parameters/headers": {

"Content-Type": "application/json",

"Accept": "application/json"

}

Then, in the outputs' body, I found the files' properties that I just mentioned. The array path is body('Send an HTTP request to SharePoint')?['PrimaryQueryResult']?['RelevantResults']?['Table']?['Rows']

However, another problem is I would like to know the groups/people (their name or email will help), who can edit the respective file as well, I found no related properties to retrieve from the path.

Thank you for reading this post. I deeply appreciate every reply.

Categories:

General topics

All responses (2)

Answers (0)

Sort by

Akah Mandela 445 on at

Like
a
(0)

Report
Copy link

Link copied!

I will suggest you add the Get file metadata action after the sharepoint action to retrieve the wanted infos from the file. You can use an expressison as body('Get_file_metadata')?['Editor']?['Email']
SDX1 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply!
Unfortunately, I have tried the Get file metadata independently, but I found no properties in the body that is named "Editor", there's only some properties like Itemid, Id, Name, DisplayName...
I have also tried to set a variable after the Get file metadata action using "body('Get_file_metadata')?['Editor']?['Email']", but the resulting variable is empty.

Updates: I found the people who I shared the file to with Get file properties action. However, I still cant find the groups that have edit rights.