I'm using Send HTTP Request to Sharepoint.
Method: Get.
Uri: /_api/Web/GetFileByServerRelativeUrl('relative link to document')?$expand=ListItemAllFields/RoleAssignments/Member/Users
Using the $expand returns JSON has null values and flow throws error. Is there a way to get item level permissions without using $expand?
Hi @rarroyo1
I have tried this and see my results below.
This is my run results:
Please check your URL is correct. Also post a screenshot of your flow and error details.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsI figured it out myself. The JSON that is returned as 3 Title fields. So after Parse JSON, add Compose action and use the 2nd Title field from the list
{
"Title": (use the 2nd Title listed from Parse JSON output)
}
This will automatically add the compose to a do for each action.
Inside the do for each action, after compose, append the compose output to an array variable.
After the do for each loop, add a Create HTML. Select the array variable and that's it!
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
24 | |
14 | |
12 | |
7 | |
7 |
User | Count |
---|---|
46 | |
22 | |
18 | |
15 | |
10 |