You’re offline. This is a read only version of the page.
30
Hi, I'm having problems with a flow. I have a flow that will create a SharePoint list, populate that list based on another SharePoint... last thing I need is to provide access to that SharePoint list.
I'm not able to use the drop down to select the List name because it's created during this flow but I've been using "Onboarding [Employee's Full Name]" and that's been working to create it, and code creating columns, and then fill in the list based on another SharePoint List. Below is the step that is failing and the error I'm getting.
The recipients are valid email addresses (masked).
Any idea what it's failing? I believe it's because of the "Onboarding [Employee's Full Name]" but is there a way to provide the access to the list?
That worked! It shows the employee assigned to that email address as having access to the SharePoint List. Hooray! Thanks for all the help.
I got an error... I replaced the 7 with the text you provided. Below is the error and a screenshot.
The expression "web/lists/getByTitle('Onboarding New Employee')/Roleassignments/addroleassignment(principalid=body('Send_an_HTTP_request_to_SharePoint_3')['d']['id'],roleDefID=1073741829)" is not valid.
Hi @jacobb3,
Replace 7 by the following expression:
Share
Report
All responses (
Answers (
body('Send_an_HTTP_request_to_SharePoint_3')['d']['id']Hi Expiscornovus,
I'm not quite sure what I'm doing and could use more direction. I was looking at a YouTube video https://www.youtube.com/watch?v=mixlWw33I00 which got my closer to my goal of assigning permission. However, in the video they were using principalID=7, and based on my screenshots below this particular user would be 12. It's not always going to be 12 as the user will always be someone else. In the "Send an HTTP...3" step I am able to "GET" the correct ID. How do I change the "7" in the "Send an HTTP...2" step to the ID received in the step above?
Hi @jacobb3,
IDs are unique per list. It is very likely that these numbers are not in sync.
In that case I would suggest to use a Get Items action and filter on the Onboarding [Employee's Name] title with a Filter Query. This way you should be able to retrieve the correct ID in the related list and use that within the grant access action.
Hi Expiscornovus,
ID 15 is from the a different list called New Hire Checklist, not the "Onboarding Gimme Access" list... I'm not sure how to add the ID for the correct SharePoint list...
The full flow is that a manager will add their employee's name, start date, their name (Manager), and the new employee's email address to the New Hire Checklist to the SharePoint List. Adding to the "New Hire Checklist" SharePoint List will trigger the automation. The automation creates "Onboarding [Employee's Name]" and then adds the needed columns, then gets data from another SharePoint list and copies them. Finally I want the new employee to get access to the "Onboarding [Employee's Name]" list, and this is the step I'm stuck on... giving access to the the full sharepoint list, not just one item on the list.
Hi @jacobb3,
Since you are using multiple lists in your solution can you double check if the Onboarding Gimme Access list has a list item with ID 15?
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
