Power Automate SharePoint Groups with flow
HTML-код
- Опубликовано: 20 июн 2024
- If you are still using SharePoint Groups, then you have probably wished a time or two there was a way to get access to those groups with Power Apps or Power Automate. Well, wish no more! This video shows you how to use the SharePoint HTTP Action to get all of the members of a group and the information about them. In the video we show emailing them via Outlook and putting the info in an HTML table. Video includes SharePoint HTTP action, Parse JSON, and troubleshooting.
Power Apps Consulting and training at www.PowerApps911.com 
Наука
@17:40 Shane: "be brave!"
--- I now tell this to myself everytime i get intimidated by codes i dont understand and have no choice but to learn it myself coz im supposed to be the powerapps 'expert' in my org (but srsly it's all just thanks to shane's videos!). Thank you so much !
I love this! Thanks for sharing.
Always learn new tips watching your videos... Today it was typing a name that's not showing in Dynamic Content and having it served up. Awesome! Thanks as always... keep up the great work.
Awesome! :)
friggin amazing video. I've been struggling with this for a few weeks and watching a few times solved the problem. Woohoo.
YOURE PERFECT SHANE
Thanks 😊
Perfect as usual, we need more about power automate.
Working on it! 😀
Hi Shane, thanks for all the amazing content as always. Can you demonstrate using a flow to compare, e.g. a Sharepoint Document Library with a List? I'm trying to write a flow that will compare folder titles to a bunch of list items and update the folder metadata on any matches--but haven't been able to find anybody online doing that specific thing (and obvs can't figure it out myself). Thanks!
You make it so simple 😎
Thank you
My pleasure 😊
Great video Shane! thank you! I am wondering if it`s possible to manage this list ( group members) in power apps? let`s say the SharePoint group is going to be the admins of an app and I want to give the admins option to manage the group from the power app
Shane, perfect, thank you! Can this be expanded to multiple SharePoint Groups as part of an approval action where several fields are SharePoint Groups selected (drop down choices) by a user in selecting the "path" their list item must travel to become approved? Thanks again!!
Excelent!. Do you have any video where you are using this in power apps? ... maybe something like initial user validation using "OnStart" ???
this has been so helpful!
Awesome! Glad it helped. 🐶
Hi Shane: Thank you for clearly explaining this complex process. It really helped! Truly appreciate it. Also, I have a case where for each department there are users listed as rows (not columns) in SP list A. I like to copy and save in another list B in a single multi user (person field allowing multiple selections) field for the record where the department is matched. Do you have a video explaining the process? If so, can you please direct me to that? As always, Thank you for sharing your knowledge! SueA.
The rows of people will be a table. You will need to put that table in the format the multi-choice column is looking for. ruclips.net/video/b4Fb57UsJLI/видео.html shows you that format. :)
@@ShanesCows Thank you for your reply. The suggested video shows "how to" with hard coded values. In my case source values are dynamic and thus I am unable to use the Hard code approach. It does explain the Table function concept very well. Thank you for that. Any suggestion on how to pull all the eight people listed as eight rows each with department Math in List A and copied on to List B in a single row with a multi People field in List B having Department Math? If Get HTTP method then what could be the Uri for that be? Thank you for your consideration.
Shane this is a great video and very useful. Do you have a video that can explain how to read a CSV file and push a items to a SharePoint list? Since this in MS GCC HIGH we can't use third party plugins or anything not supported by GCC High.
Check this video out on pulling in Excel data and saving it to SharePoint. Maybe it will give you some ideas. ruclips.net/video/QcWjAt7QVn4/видео.html OR this video on cut and paste should let you do it also ruclips.net/video/foGaOrBzVLc/видео.html 😀
Hi Shane, thank you for your very informative video, i have a query , how can we dynamically get the sharepoint group of a document using powerapps ?
I don't know that one. Sorry
Hi Shane, Thank you for all your informative videos. Can you please create a video on Filter or Look up data between 2 SharePoint where they have same column names. The main issue is I can't do "Title = Title". I didn't find any information with respect to this over internet.
Could you post an example of a lookup/filter you're using? In one of my apps I have two separate SharePoint lists in an effort to have a list of items in an inventory that relate to a list that corresponds with check-in or check-out events. The way you query is dependent on what list is the source of the lookup. For example if my list of inventory items is MyInventoryList and my list that has check-in and check-out events is MyInventoryTrackingList, and I want to see all the check in/check out history for a particular inventory item, it would look like this to filter for it:
Filter('MyInventoryTrackingList', Title = 'MyInventoryList'.Title)
I am filtering the MyInventoryTrackingList on SharePoint where the column 'Title' matches the MyInventoryList on SharePoint. So the column you are using that is outside of the source you are filtering by requires the listname followed by a dot, and the column name. If this filter were placed in a gallery as items, it would list all the items on the tracking list with an ID that matches the item in the MyInventoryList.
Hi Shane, I'm really new to PowerAutomate and PowerApps but have found your videos really helpful and easy to follow, thank you. Could you use the logic in this video to get details from a MS Teams Group? I need to write a flow that removes members from a Teams group. Each time I get close I get an error 'Resource '6b6acd92-e52c-450f-b624-cfe5fcf213d3' does not exist or one of its queried reference-property objects are not present' The comparison data is held in a SharePoint list. I'm using the UPN which in this case is an email address but keep getting the error. Thanks :)
Watch out for those semicolon delimiters. Flow has a bug where sometimes it does not save the delimiter on you. You save got back and its not there.
Mostly we use nested Azure Ad group other than users in SharePoint groups. We can use the Office group connector to get the group members that way which is cool.
Good stuff!
Hi Shane,
Your videos are so awesome. Can you please create one on adding Functional accounts on Flows.
That is a good idea. :) I like it and will add it to the list. Thanks
@@ShanesCows Thank you so much
Thanks for sharing this video very helpful. Is there a way to access SharePoint groups even without having access to a certain SharePoint site? This is what I've tried so far, I have a separate account, used that account to publish the Flow, have that account to have full control access to the site. So when I check the connection it is using that separate account with full control access to the site. But then if other users with no permission to the site run this flow, it's giving an access denied error. TIA.
Hi Shane, When I get to the part where you Parse JSON, when I copy the 'body' out of the Content box and paste it in the expression box, I get "@{body('Send_an_HTTP_......" but in your video you had "@(outputs('Send_an_HTTP_....". Why am I seeing 'body' instead of 'outputs'. It's been driving me bananas since last week. Thanks for any help you can provide.
Hi Shane this was life saver. Only one problem, I have 5 people in the group. It sends the first email with the first 2 names on the group, then send second email with the first 3 names and so on. So getting duplicate emails. How can I correct this?
Hi Shane, thanks again for another great video. It seems I run in the same problem again as in my other previous attempts. The send HTTP request is working. In step 3, Parse JSON, Content when I insert [body] and copy paste the content in a text editor the format is like this ... @{body('Send_an_HTTP_request_to_SharePoint')} ... Completely different from yours. I have tried several possible changes but nothing works. Seems like my result is never a string.
YOu can email a screen shot or two and I will try to take a look. shane at powerapps911 dot com
Adding Records to Dynamics 365 Finance and Operations from a Canvas App.
I have created an application on Canvas and I want to send the data to my Dynamic 365, and I am saving it in Dataverse, so I need help with that.
but I don't know how to do that, can you explain this issue in the video?
This video is a lifesaver, i have gone through this video over and over, but i am still getting the following error:
InvalidTemplate. Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.
David if you look at the ParseJSON schema that it autogenerated for you at the bottom if a required section. Remove Content and then rerun it.
@@ShanesCows thank you for replying so quick, upon looking at the schema, unfortunately the required section doesnt show content for some reason, so no idea why its looking for it :(
under required i have the following:
"__metadata",
"Alerts",
"Groups",
"Id",
"IsHiddenInUI",
"LoginName",
"Title",
"PrincipalType",
"Email",
"Expiration",
"IsEmailAuthenticationGuestUser",
"IsShareByEmailGuestUser",
"IsSiteAdmin",
"UserId",
"UserPrincipalName"
Could it be one of these that is the issue?
Hi Shane, is it possible to remove all the users from a SharePoint Group at once with Power Automate? Thanks!
Hi Shane, if possible how can I integrate the power automate in my Web base application outside of office 365 Thank you in advance
Power Automate flow has an HTTP trigger endpoint you can call.
@5:25 my flow ran successfully but when I go to the outputs, it only gives me a link Click to Download. I'm guessing this is because my list of group members that the flow is pulling, is pretty long. I downloaded it but it doesn't look anything like what you have. any ideas on if I'm doing something wrong?
I don’t. If you called it correctly it should look the same no matter the volume. Maybe check the headers for api call?
ok, I re-watched carefully a handful of times...and it worked! then I hit the issue of null UserId and I added the null...it wasn't working. Rewatched a bunch of times and finally realized I accidentally forgot the comma after the square. I'm working on a big list of people, so I put the email addresses in the body of the text to test it out first. ta-da!! thanks for such an incredibly helpful video and going over the potential errors you will face.
What the best solution to pull users from multiple Sharepoint groups?
You would have to take this concept and loop through all of the groups I think.
Have you tried this with Group(0)?
Disregard...I should have used "/_api/web/siteusers?"
Glad you got it!
You could get the same output without having to parse the JSON and only use expressions. In your Apply to Each control use the expression outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results'] as the output from a previous step. Then in your Append to Variable step use the expression items('Apply_to_each')?['email'] as the Value. Also remembering to include the semicolon in the Append to Variable value.
Very true Luke. 🤩 The challenge is that is a lot of hand coding that makes it super hard for non-IT people, so I also look for the way to do it with the least amount of "code". Great tip!