Dear all,
I'm trying to add users a sharepoint site via power automate.
I can provide email, id or any necessary data to flow but i can't find a way to do this.
I read this article but didn't work for me, result always return blank.
Is there any other way to do this?
Thanks in advance,
Hi@Anonymous @Expiscornovus I am trying to change the Created By column to display the user who has created the item on sharepoint list. In my case, the person who creates the item on Sharepoint could be any user.
Due to the 'Create Item' command i have in my flow, sharepoint by default autopopulates this field with my user name (as i am the flow owner). In this case, the person who creates the item on Sharepoint could be any user.
I was looking at the post which you said helped you, however, in the post, the author has already a designated user which he would like to assign in the Modified By column.
Do you know the way to change the user in the Created By from me to the user who actually created the item on SP?
I need this to update Created By to ensure that item-level permissions in a list worked correctly.
I used Teams Site and add member to Team via Flow.
It solved my problem.
I am also facing this error. But in my case I am not able to get group values added to the site name . I have followed all steps.
https://normyoung.ca/2020/10/22/add-and-remove-users-to-a-sharepoint-site-using-microsoft-lists-and-power-automate/
concat(variables('varSiteName'),'',triggerOutputs()?['body/Group/value'])
Please help.
Hi @Anonymous,
Can you run a GET request for SiteGroups without a filter as a test? Just want to see if the PowerAppsDemo Members group is listed in the whole list of SiteGroups.
Maybe it is a case of the Title of the group being different compared to the LoginName.
_api/web/SiteGroups?$select=Id,LoginName,Title
Hi @Anonymous,
Just to double check. The SiteGroup does exist in the interface on the site itself?
Hi @Expiscornovus ,
Thats the only thing all we need 🙂
Here is an updated one, the name (PowerAppsDemo) and type (Members) are looks correct to me.
Hi @Anonymous,
Apologies, I got confused. I need another coffee. The Group column is not the issue, since it was showing the Members label of the choice column. My bad 😅
I think we need to focus on the varSiteName variable value (the SiteName field value). For some reason it is returning as empty? Did you check the outputs of your flow run. Does it show up in your trigger action outputs for example?
Hi @Anonymous,
The name of the column in your SharePoint list could be the issue. Did you setup the choice column in the List with the same name, Group?
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional