Thank you for sharing all this knowledge, your channel is worth its weight in gold. I could have a text repository of all common actions used and just like that be in business in another flow. Wow 🤗
@RezaDorrani3 жыл бұрын
Thats the idea behind this. Build your own code snippets and share it with others.
@amansharma7513 жыл бұрын
@@RezaDorrani Sir how can I access SharePoint groups in PowerApps or please elaborate or make a different video on this
@RezaDorrani3 жыл бұрын
@@amansharma751 my most recent video shows how to check if user is member of a SharePoint Group. To get all SharePoint group members, I will have to explore and see if there is a trick way :) If I get a neat trick then I may do a video on it.
@xuyennguyen71103 жыл бұрын
Wow! That pasting to the clipboard. It's so impressive! Thanks a lot for sharing.
@RezaDorrani3 жыл бұрын
Thank You
@ryanbond80223 жыл бұрын
Reza, this is awesome. Thanks for the snippets - will save me a lot of time! I plan to go through all of your automate series.
@RezaDorrani3 жыл бұрын
Glad you like them! Enjoy the automate series.
@nharzic9248 Жыл бұрын
Thank you. This is an amazing tip and something I had been struggling with for a long time. It did not occur to me that you could use the SharePoint HTTP request to access a list of users in a SharePoint permission list. And amazingly there are 'two for the price of one' pieces of advice as it is really helpful to be able to copy an paste scoped actions. This is, as always, a very clear and extremely helpful video.
@RezaDorrani Жыл бұрын
Awesome! Thanks so much for watching.
@rajaamohammed69653 жыл бұрын
Useful tips & tricks about power automate. one of the best content deliver so far related to power platform. Keep it up and kudos to your effort.
@RezaDorrani3 жыл бұрын
Thank you
@365g3 жыл бұрын
Excellent video Reza - all very relevant to what I am currently looking at. Loving the sharing tip - will be a big help in my org. Cheers!
@RezaDorrani3 жыл бұрын
Thank You
@emilgrzyb36533 жыл бұрын
Perfect timing. Exactly the alternative I needed for that annoying Parse JSON . Thx RZA
@RezaDorrani3 жыл бұрын
Thanks Emil
@DanielADamico3 жыл бұрын
Always sharing awesome tips and tricks!👏👏👏
@RezaDorrani3 жыл бұрын
Thank You
@bibiwiki Жыл бұрын
Hi. I can say your videos are really sensational. I'm now exploring Power Automate and MS automation process, and your materials are really helpful. Thank you!
@RezaDorrani Жыл бұрын
Great to hear!
@passais6 ай бұрын
Absolutely Excellent and time-saving tutorial!
@RezaDorrani6 ай бұрын
Glad it was helpful!
@robofski3 жыл бұрын
WOW, that is such a cool tip, copy and pasting actions as text, I feel a library of actions coming up! I wish variables could be added to a scope that would really take the possibilities to the next level but this is still such a useful feature. Yet another Reza video where I learn something that will make my life easier!
@RezaDorrani3 жыл бұрын
Thank you Dan. It surely is super powerful. Let me know what library of actions you feel are helpful. I have provided 3 to start with as part of this video.
@shaiksamad15623 жыл бұрын
Reza.. You are Brilliant .. Valuable tips
@RezaDorrani3 жыл бұрын
Thank You
@Mx813 жыл бұрын
Thanks again for these tipps. Damn, I love the clipboard function, but that was totally new for me. Thanks! 👍🏻 Concerning the „copy peek code part at 5:35“: For getting the array without going to the peek-code, I’m • selecting „expressions“ • enter a space (or whatever), • change back to „dynamic content“ • select „the Output“ • going back to expression and delete the firstly inserted space and extend the whole expression with the concerning fieldnames. And last not least: I love the possibilities the SharePoint _api offers, but there can be done a lot of bad things with it, so I‘ll not present it to our users. 🤐
@RezaDorrani3 жыл бұрын
Yes the api has a lot to offer and a lot can be done with it. It does respect security though. So a user cannot potentially access data they don’t have access to.
@Mx813 жыл бұрын
@@RezaDorrani how about the „ValidateUpdateListItem()“ API. With this, I can change the Editor/Author fields. So for me, that’s a risk because maybe many user trust in that fields.
@MrKlee7773 жыл бұрын
Thank you Reza for sharing all your knowledge!!!
@RezaDorrani3 жыл бұрын
My pleasure!
@prathimap41962 жыл бұрын
Thank you so much you are saving my day.. really your videos are so useful
@RezaDorrani2 жыл бұрын
Happy to hear that! Thanks for watching.
@NaveenKumar-lm7qj3 жыл бұрын
Excellent Reza....thanks for sharing this😊
@RezaDorrani3 жыл бұрын
Thanks Naveen
@jrockno3 жыл бұрын
Great stuff as always, Reza!
@RezaDorrani3 жыл бұрын
Joey my friend. This is your work I am showcasing. You are the best.
@Maqai1233 жыл бұрын
Very useful tips. Thank you for sharing.
@RezaDorrani3 жыл бұрын
Most welcome
@golfnutt83 жыл бұрын
Outstanding, thank you for another awesome video!
@RezaDorrani3 жыл бұрын
Thanks again!
@emmanuelokwuosa644110 ай бұрын
Wonderful. Thank you very much !
@RezaDorrani10 ай бұрын
Most welcome
@lizlsnyman-bouwer42383 жыл бұрын
This is so powerful! Thank you for sharing :)
@RezaDorrani3 жыл бұрын
Thank you for watching.
@darkmatter53102 жыл бұрын
This is very helpful appreciate!
@RezaDorrani2 жыл бұрын
Your most welcome
@alhakawaty5 ай бұрын
You are fantastic! Thank you!
@RezaDorrani5 ай бұрын
You are so welcome!
@ally1708 Жыл бұрын
thanks Reza you're the best
@RezaDorrani Жыл бұрын
Most welcome
@SLTechBuddyChannel2 жыл бұрын
Thank you so much share this valuable content
@RezaDorrani2 жыл бұрын
My pleasure
@rubenabrahamparedesjimenez5148 Жыл бұрын
You made a useful and amazing video
@RezaDorrani Жыл бұрын
Glad to hear that
@anthonydiliberto42612 жыл бұрын
You are the man
@RezaDorrani2 жыл бұрын
Thank You!
@Kremsi73 жыл бұрын
This is Genius! Very Good! Thx 2 u
@RezaDorrani3 жыл бұрын
Thank you
@zghaboos2 жыл бұрын
Just 👌👌👌
@RezaDorrani2 жыл бұрын
👍
@sundrapillay66683 жыл бұрын
Thanks Reza
@RezaDorrani3 жыл бұрын
Thanks Sundra
@julien89793 жыл бұрын
Thank you Reza for this excellent video. I would suggest for later videos on how we can change the user role to Edit if the user role has view-only before performing the create an item or a file action in SharePoint and after the create action succeed how we can assign back to the same user the view-only role.
@RezaDorrani3 жыл бұрын
Thanks for watching. Will add your suggestion to my backlog
@julien89793 жыл бұрын
Thank you Reza, appreciate it!
@ArohShukla3 жыл бұрын
Wow …such a wonderful video…. code snippets to notepad and put into another tenant is fantastic tip. Question: Is it possible to automate Office 365 Security groups / Microsoft 365 Groups into SharePoint? Meaning, when a new security group has been added at M365 admin center, this new group automatically gets access to specific SharePoint site? Please advise.
@RezaDorrani3 жыл бұрын
Thank You for your kind words. Key will be to figure out how to trigger a flow when a new Security Group is added & which SharePoint site it needs to have access to? You could create a manually triggered flow which takes 3 inputs properties. 1 - The ID of the new security group 2 - SharePoint site url 3 - SharePoint Group Name Then flow can read all the above properties and accordingly assign the AD group to the SharePoint Group for the SharePoint site.
@ArohShukla3 жыл бұрын
@@RezaDorrani thanks brother for your valuable inputs. 🙏
@KirahDaw2 жыл бұрын
Thank you thank you thank you again and again and again.. lol!!! 😊😊😊
@RezaDorrani2 жыл бұрын
You are so welcome!
@jbo1253 Жыл бұрын
Thank you again for another great video. Is there a limit on how many users you can pull from a SPoint group? My group has 120 users but i'm only returning the first 30. That is also the page limit of the group view. Is that the reason only 30? If so I do not see how to increase the the limit of users on a group page view.
@RezaDorrani Жыл бұрын
I was not aware of that. As its an API, must have limits. I’m not sure if there is a workaround. Something I would have to investigate on. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@jalbers1955 Жыл бұрын
Hi Reza, thank you for all your amazing instruction videos. I have a problem with the Copy to clipboard part of this video, if I follow all the steps I am able to paste the link from the copied actions into the Copy to clipboard but then it refuses to past once I click the part I just copied in. I have that a lot with the Clipboard, most of the times it works when I paste in the same flow but it should work in between flows as well, isn't it? Have you ever encountered this behavior and do you have a solution to it?
@RezaDorrani Жыл бұрын
I have not faced this issue.
@golfnutt8 Жыл бұрын
Hi Reza, your videos are very informative. In this video you are adding group memebers but what if I wanted to create a custom group? How do you create a SharePoint user group if a group doesnt exist?
@RezaDorrani Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to know the way it can be done. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@branzo793 жыл бұрын
This is great. Is it possible to do this for a custom SharePoint list of users/staff? can I send an email to a specific 'meta data filtered' instance of users in that custom list? Example, if I have 10 users, and 3 are 'Admin'...can i send to just those 3 Admin users within a list of 10 users overall? does this concept work for custom lists using the meta data & person or Group column type?
@RezaDorrani3 жыл бұрын
Concept should work. Flow logic would be different. I would have to recreate your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@divyanshuverma77282 жыл бұрын
Hey @Reza Dorrani, excellent video. i just implemented this and worked well, but at some time i got error "Access is denied" while getting SP group members using Send an HTTP request to SharePoint..... Please suggest what i need to do in that case?
@RezaDorrani2 жыл бұрын
My guess is the group visibility is set to group owners or members only and you are not an owner or member or you are using incorrect url to SP site or list. I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@juancsanchezv3 жыл бұрын
Thanks a lot! This is amazing. What other uses does the scope action have besides grouping actions?
@RezaDorrani3 жыл бұрын
You can handle errors for all actions within the scope together + scopes help organize your flows
@BrianSheehan50138 ай бұрын
Hi Rezza. Thanks again for a great video for us new users. I have a question related to this video. I have a flow for approving a training request. I have 2 groups that the approval can go to depending on whether the request is coming from an employee on Day Shift (A Shift) or from Night Shift (B Shift). Can you point me to a video that would help me write the expression needed for my flow to be able to choose which Group to put in the Assigned to field based on information coming from my trigger action (When an item is created?
@RezaDorrani8 ай бұрын
I have done multiple approval based videos and are all placed in a playlist on my channel. I would recommend checking in that.
@MrNaquevedo3 жыл бұрын
Hi Reza, I don't see the "Email Formatting" option on my end; was this option taken out? And thank you so much for your knowledge library; I been learning a lot from you. Thank you!!!
Hello Reza, Thank you so much for the great videos. your Chanel is the first source I come to get knowledge. Can you please guide how we can get email ids by calling an AD group? My scenario is I have a SharePoint group in which I added an AD group (Instead of individual email ids) so, please guide how i can get email ids to send the email. Thank you
@RezaDorrani2 жыл бұрын
You can read members from AD Group inside SP Group. You will directly need to query AD Group members. This video description has link to sample on how to do that.
@HinaGeo2 жыл бұрын
@@RezaDorrani Thank you so much. The only great words of thanks i can say Jazaak ALLAH Khayr (My faith words)
@jljchnicosia21293 жыл бұрын
Ohhh copy and paste the 'scope' is really usefull! Tnx for sharing. ...but when sharepoint groups contains AD security group, where is the practices to recovery mail? I should use http connector for calling graph api?
@RezaDorrani3 жыл бұрын
Yes the Azure AD connector for security groups and the Office 365 group connector for Office 365 groups. The video description has a link to 3 code snippets I have shared. Both Azure AD and Office 365 group are in there.
@jljchnicosia21293 жыл бұрын
@@RezaDorrani Great Job, tnx for sharing
@karlgerdschneider69653 жыл бұрын
@@RezaDorrani i wonder how i can fullfill a special challenge with a Person/Group SharePoint Column with Multivalues. This multivalue Peoplepicker contains many single Users, some SharePoint-Groups, some AD-Security-Groups and also a bulk of Microsoft 365 Groups. All possibilities mixed up in one Column. I dont have a glue how to resolve these Multivalues and the member of the different Groups to semicolon-separated E-Mails or Claims for usage in Flow Approvals or Grant Permissions-Actions
@RezaDorrani3 жыл бұрын
@@karlgerdschneider6965 I would have to try out your scenario to provide any guidance. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
@TheBananisen3 жыл бұрын
Thanks for sharing - just love following your channel. Dear Reza! Do you know if there is a max limit of emails in the converted array added to the To: Cc: Bcc: email field? Have a group with +700 users which the solution could be used to send a newsletter for exampel. Take care and once again thank you for sharing.
@RezaDorrani3 жыл бұрын
Not sure what the max limit is to be honest. Ideally if you have 700 users, would be best to put them in an email enabled security group in AD. You can add security groups to SharePoint groups + you can directly email the group address so all users will get the email.
@davidwebster26162 жыл бұрын
Reza, at the beginning of the video, you started talking about midway through your flow, is there a different video that explains the beginning steps of that flow?
@RezaDorrani2 жыл бұрын
Flow that sends the HTML Table as an email? Here is that video kzfaq.info/get/bejne/jNSHmpB21N6XZ4U.html
@toqeerh105822 күн бұрын
Hi Reza, I was able to implement this correctly, thank you. Is it possible to do a serial approval flow using SharePoint groups?
@RezaDorrani22 күн бұрын
Possible
@ryanlyons99822 жыл бұрын
Thanks for sharing - Is it possible to get email addresses of the members of an M365 group, instead of email addresses of members of a SharePoint group?
@RezaDorrani2 жыл бұрын
Video showcases how to get members of O365 groups which are now renamed as M365 groups.
@shreyarair3 жыл бұрын
Hi Reza, Excellent video! However I would like to know how to trigger emails to multiple groups chosen dynamically from people or groups picker in SharePoint list or power apps? Thanks
@RezaDorrani3 жыл бұрын
Depends on the flow trigger. You would have to anyways query SP to get the group members. I will recommend you check on the forums also at powerusers.microsoft.com/
@meetmak1 Жыл бұрын
Super Useful.....had one question can we also get the title & department from the Sharepoint group alonwith the Name and email, thanks in advance...
@RezaDorrani Жыл бұрын
I believe the JSON response has all the info you need. If not, you could always query Office365Users connector to get the information.
@meetmak1 Жыл бұрын
@@RezaDorrani Thanks for quick reply, JSON response is not having the info, but the office365user connector has the info.
@user-dy8pe1lg3z3 жыл бұрын
Thank you for sharing. Due to we cannot lookup data from Personal or Group column. I am not sure your knowledge sharing can be applied to my scenario? Could you please suggest? Thank you in advance.
@RezaDorrani3 жыл бұрын
Not sure I understood your question
@krishnabairi15813 жыл бұрын
Hello Reza, thanks for sharing knowledge. I have a use case that I need to send a list of items (from excel report)to the department owners they own as a table in the email... Could you please make a video to create custom html tables?
@RezaDorrani3 жыл бұрын
Added to backlog. So basically get data from SP or excel and create HTML table and send in email?
@krishnabairi15813 жыл бұрын
@@RezaDorrani thank you for responding back. You are right but create table with the items that each owner responsible and send it to owner. When I use create html table, it is creating table with all items, I failed to add right condition.
@RezaDorrani3 жыл бұрын
@@krishnabairi1581 So did u get it working?
@krishnabairi15813 жыл бұрын
@@RezaDorrani not really, it is creating table with all items instead of creating custom table for each owner that they responsible. I need to send an email to each owner with the items they own. My data source is just an excel dump. It will be really helpful if you can assist, I have nearly 1000 emails to send out. I could add plain text in email instead of table but each owner has more than one record.
@RezaDorrani3 жыл бұрын
@@krishnabairi1581 I understand the request but this is something that I would have to tryout and then blog about. For faster assistance, try posting your query on the community forum powerusers.microsoft.com/t5/General-Power-Automate/bd-p/MPAForum
@eduardocoello12163 жыл бұрын
How would you use the same filter array but with a Start and Wait for Approval action? I want to get the approver and comments of an approval action (It is first reply only, so just one approval). What syntax would you use?
@RezaDorrani3 жыл бұрын
I think I have covered plenty of scenarios around approvals - kzfaq.info/sun/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
@divyak8545 Жыл бұрын
Thank you so much Reza, can you please let me know whether it's possible to know whether the one drive files are shared with other users and what is the permission the user is having edit or read.
@RezaDorrani Жыл бұрын
I would say its possible but I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@divyak8545 Жыл бұрын
Thank you for reply, I have checked the forum.. It didn't help me.
@RezaDorrani Жыл бұрын
@@divyak8545 You can also ask for help there. Forums will be your best bet as I have not tried this scenario.
@cztop543 жыл бұрын
Reza, I have a large sharepoint list. A column in that list indicates what permission group each person should belong in (actually a job title). Is there a way to have Power Automate add and remove members to Sharepoint permission groups when a new item is added or changed? For instance, if I add someone, can I have the list add them to Permission group A or permission group B (based upon job title). Or, if I change their title, remove them from one permission group and put them in another or if I delete someone, remove them from the permission group. It seems that should be possible but I can't seem to find a tutorial even similar. Thank you.
@RezaDorrani3 жыл бұрын
Possible - Yes. Is there a tutorial - I am not sure. I have not done that. In Azure AD, there is also an option for defining dynamic group membership. Try and explore that option. I would recommend you check on the forums as well at powerusers.microsoft.com
@anilalladi2 жыл бұрын
Hello Reza. I appreciate your efforts and help for the community. Is there any way to get the list of site collection admins?
@RezaDorrani2 жыл бұрын
You would need to use the SP rest api action in flow to get that. There should be a rest api endpoint to get the site collection admins. You will have to check for that.
@atulvijay100 Жыл бұрын
Hi Reza, I have request to add members to sharepoint group when person is added to a list. I have used send an HTTP request to shareopoint connector. The flow is working perfectly. The problem i am having is that when i add a person manually to a group, i can turn off send email notification but i am not able to do it with the flow. Can you please guide me in how to do it
@RezaDorrani Жыл бұрын
I have not tried this and hence not sure what the path is. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@alzaimoor793 жыл бұрын
Excellent, can we copy and past switch too?
@RezaDorrani3 жыл бұрын
I did not try but it should work.
@Thor_Underdunk_Caballerial Жыл бұрын
5:38 The code is different for me when I peek code, I have - "from": "@body('Sharepoint_Group_Members')", rather than "from": "@outputs('SharePoint_Group_Members')?['body']", Does anyone have any suggestions where I've gone wrong, or how to proceed?
@RezaDorrani Жыл бұрын
Video description has link to download flow snippets. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@Sunilprakashsabbithi3 жыл бұрын
Hello Reza, I like this one. Is there any way to accomplish this: When a user can enter the URL for a SharePoint Online site (power app form) and it could return the owners of the SharePoint site? any suggestions please ?
@RezaDorrani3 жыл бұрын
Trigger flow from Power Apps, pass the Site URL, use same technique as in video to get group members (Owners group) and send response back to Power Apps. I have videos on my channel that show how to pass data from power apps to flow and vice versa.
@Sunilprakashsabbithi3 жыл бұрын
@@RezaDorrani Thanks Reza I am able to get the site owners for one particular site by the membership of of that particular site, but is there any way to get the details for all the sites in the tenant ? I mean any generic membership is for full control users ? I tried to use the role based I'd code but it's not working. Any ideas ?
@RezaDorrani3 жыл бұрын
@@Sunilprakashsabbithi I am not sure about it. Something that I would have to investigate.
@Sunilprakashsabbithi3 жыл бұрын
@@RezaDorrani Thanks Reza for your prompt reply. Your ideas are so useful as you give all the basics while implement ing them with good explanation.
@premsaini4289 Жыл бұрын
Thank you Reza, what if I need to ahow the members in gallery instead of sending email?
@RezaDorrani Жыл бұрын
Power Automate does not have concept of a gallery.
@premsaini4289 Жыл бұрын
@@RezaDorrani I mean is there a way to send the output to powerapps and the show it in gallery.
@RezaDorrani Жыл бұрын
@@premsaini4289 There is an action to send data back to power app. You can try using that. I have shown that action in different context in other videos. You can check those.
@dipanjanchakraborty55692 жыл бұрын
how to make a flow when I can fetch url from Sp list and return all the site owners of that particular site url...please make a video on that
@RezaDorrani2 жыл бұрын
Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
@jagadeesanm78754 ай бұрын
Hello Reza, Is there a way to dynamically select the sharepoint groups from the list and send an email for notification purposes?
@RezaDorrani4 ай бұрын
Where will you select it from?
@jagadeesanm78754 ай бұрын
@@RezaDorrani I've created a list for all my ticket and created a column for the persons/groups to the notified
@RezaDorrani4 ай бұрын
@@jagadeesanm7875 You can query that list and get the emails to send to. Not something I have a video reference for though.
@jagadeesanm78754 ай бұрын
@@RezaDorrani Exactly, that’s the plan. But in the video you’ve mentioned to consider the ‘id’ of the group, would you mind sharing it how to take that dynamically
@RezaDorrani4 ай бұрын
@@jagadeesanm7875 I did this video a long while ago and do not remember the specifics. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@warkeyash00710 ай бұрын
Hey is there a way to add members into the yammer groups as well....
@RezaDorrani10 ай бұрын
Not something I have explored hence not sure
@TheFearBO Жыл бұрын
Hey Reza, is there a way to dynamically enter that group ID?
@RezaDorrani Жыл бұрын
It can come from dynamic content. Does not have to be hardcoded
@TheFearBO Жыл бұрын
@@RezaDorrani Just how would I get that information? So right now I have a sharepoint list that uses the people/resource column. In there I have groups, how do I pull the group ID from that SP list? Using Get Items, I don't see what dynamically pulled information I can use to capture the group ID within List Group Members
@RezaDorrani Жыл бұрын
@@TheFearBO I do not have a specific video on this. I would have to try it out to give the exact steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@ipsitasahu90403 жыл бұрын
Please create a video to rename a file or else if you have any link for this please share it
@RezaDorrani3 жыл бұрын
I have seen plenty of solutions around file renaming on the forums. Try posting your query here - powerusers.microsoft.com/t5/General-Power-Automate/bd-p/MPAForum
@nduagubadev3 жыл бұрын
How do I fetch Individual office profiles and display only their names alone in the flow
@RezaDorrani3 жыл бұрын
Use the Office365users connector.
@nduagubadev3 жыл бұрын
@@RezaDorrani yea I'm asking with regards to this video... I want to seperate the name that displays on the mail to just the Individual who receives it
@RezaDorrani3 жыл бұрын
@@nduagubadev Not sure I understand which name. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com