Check if User is Member of SharePoint Group in Power Apps

#PowerApps #CheckUserMembership
This video on Check if User is Member of SharePoint Group in Power Apps will provide a walk through of how to check if the current logged in user is a member of a SharePoint Group.
This technique can be expanded to check if user is member across multiple SharePoint groups or AD groups.

Пікірлер: 240

  • @Lagging69
    @Lagging694 жыл бұрын

    I knew I've subscribed to the right guy for Power Platform solutions. You're the man 👍🙂

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Welcome aboard!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    You surely have :) Thank you for subscribing and I hope to keep providing valuable content.

  • @MoTechConsulting
    @MoTechConsulting Жыл бұрын

    This is absolutely genius. I know this is old content but this is an amazing work around.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thank You so much!

  • @NKBobcat
    @NKBobcat4 жыл бұрын

    I had a customer ask for this last week. I didn't have time to research but after I saw another of your videos, I subscribed. Then I saw you have done this and I knew i subscribed to the right channel! Thank you for all your hard work!!!

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Thanks for the sub!

  • @vpavan007
    @vpavan0074 жыл бұрын

    Simple and sweet all we need to know is how to play with existing old school stuff, but I can clearly see your extensive experience and exposure to come up with this solution. Great video Reza... !!

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Thank you

  • @nickistern9379
    @nickistern9379 Жыл бұрын

    This is exactly what I was looking for and only have to maintain the SharePoint Group. Thank you!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @debpriyaacharya6250
    @debpriyaacharya62503 жыл бұрын

    Just Genius!! How come, every time i am stuck in powerapps, it is your videos that solves the problem. I am disappointed that youtube allows us to like a video only once.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    🤩 Thank you for the compliments

  • @mariecastine134
    @mariecastine1343 жыл бұрын

    I am so glad I found this!! it is so much easier than doing the Power Automate check user group option and it works consistently! Thank you!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Glad it helped and thank you for watching

  • @teresaagustin5191
    @teresaagustin51914 жыл бұрын

    Great video Reza! Thanks for sharing your knowledge with us. Please keep the videos coming. They are super useful!

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Thank you Teresa

  • @MukundGovindarajan
    @MukundGovindarajan2 жыл бұрын

    Something so easy i have been searching for, and there it works without any flaws.. thanks for making it so easy to learn and setup.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    You are most welcome!

  • @tenisviejos
    @tenisviejos3 жыл бұрын

    LoL This video literally kept my at the edge of my seat... I had used the list approach, and even a flow to check via sharepoint API if an user/email is part of a sharepoint group. This trick is just fast and honestly, plain brilliant. I hope the bug in the Datasource info function gets fixed... One of these days...

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you

  • @liviubocsanu5546
    @liviubocsanu5546 Жыл бұрын

    Brilliant! Works like a charm on the first try. Thank you so much!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Most welcome

  • @AssassinUK
    @AssassinUK3 жыл бұрын

    I had to subscribe just based on how great this video was! WOW!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thanks for the sub. Hope to provide many more valuable videos.

  • @RegalEase
    @RegalEase2 ай бұрын

    This is still relevant and was very helpful. Thanks Reza!

  • @RezaDorrani

    @RezaDorrani

    2 ай бұрын

    Glad to hear it!

  • @theresebaker4515
    @theresebaker45154 жыл бұрын

    Thank you for making this video. You really are gifted and brilliant PowerApps Guru!

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Thank you for your kind words.

  • @chaitanyakumar2023
    @chaitanyakumar20233 жыл бұрын

    Reza , You are Outstanding MVP ...I am Following you Quite Sometime . Your Examples are Summing up for all the Seamless Automation !

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank You for your kind words

  • @abugslife2461
    @abugslife24612 жыл бұрын

    Thank you so much!! This was very helpful and easy to understand and follow :)

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad it was helpful!

  • @leandrovegacr
    @leandrovegacr2 жыл бұрын

    What a clever solution! You are so creative man, it's awesome. Thanks!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thank You! Simple trick but highly effective.

  • @mahalakshmidevarajan6656
    @mahalakshmidevarajan66562 жыл бұрын

    I can't say how much I am thankful for this video, I have learned a lot from the video, simple and easy to understand, I am a new beginner, it is helping me day by day

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Great to hear!

  • @georgethomas9062
    @georgethomas90623 жыл бұрын

    Brilliant and Intelligent approach. Worked like a charm

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you George

  • @PowerAppsEdu
    @PowerAppsEdu3 жыл бұрын

    Great video, Reza! Thanks a lot for sharing, God bless you.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you Eduardo

  • @tomislavkarafilov2178
    @tomislavkarafilov21783 жыл бұрын

    Like this, very helpful! A good pattern! Thank you for sharing!!!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you for watching Tomislav

  • @AnoopKumar-qx8to
    @AnoopKumar-qx8to3 жыл бұрын

    Reza Sir ..This is super simple approach..thanks for sharing .We implemented same using list & flow you explained earlier which was somewhat complicated.Thanks again.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    You are most welcome

  • @andresarmas25
    @andresarmas254 ай бұрын

    Great, thanks for the explanation!

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    Welcome

  • @GraemesAdventures
    @GraemesAdventures2 жыл бұрын

    That's a very tidy solution to this - thanks for sharing

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks Graeme

  • @vishalindia1970
    @vishalindia19704 жыл бұрын

    Awesome trick. This situation has been a nightmare for many

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Agreed. This is a must use when working with SharePoint Groups for security purposes.

  • @akkaradechsrithongchai7766
    @akkaradechsrithongchai77662 жыл бұрын

    This is my answer that i am looing for, Thank you

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad to hear that.

  • @oracleHill
    @oracleHill3 жыл бұрын

    Nice workaround. Shout-out for you!!!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you

  • @asifkhawaja
    @asifkhawaja4 жыл бұрын

    Heyyy Reza, you are genius! Great idea, will be so much useful. Keep them coming please. Thanks.

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Thank you! Will do!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you Asif. Trying my best :)

  • @tmcpang
    @tmcpang4 жыл бұрын

    Wow! this is clever. Thank you so much for sharing.

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Thank you! Cheers!

  • @prosenjitbiswas7738
    @prosenjitbiswas77382 жыл бұрын

    Just awesome, thanks you sir! keep up the good work.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thank You

  • @antoniobranderas
    @antoniobranderasКүн бұрын

    I have an access control list for the limited number of technicians we have and it works like a charm. On the list I have a column for the app name, if the user is active or not, their role, and the app mode. Works brilliantly. And I have four apps accessing this access control list. Each have their own specific roles.

  • @RezaDorrani

    @RezaDorrani

    Күн бұрын

    Ok

  • @davidoff1017
    @davidoff10173 жыл бұрын

    Wow. This is a great solution. Thanks for sharing this.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thanks for watching. Have more coming in future.

  • @aysanhaghani5271
    @aysanhaghani52712 жыл бұрын

    Thanks, Reza! You`re the best

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    👍

  • @aysanhaghani5271

    @aysanhaghani5271

    2 жыл бұрын

    @@RezaDorrani I wish there was a way to give admins access to add and remove members ( to the SharePoint group) from the app)

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@aysanhaghani5271 Only option would be via flow or custom connector.

  • @breadandcheese1880
    @breadandcheese18806 ай бұрын

    Great Video Reza -Ji!

  • @RezaDorrani

    @RezaDorrani

    6 ай бұрын

    Thanks

  • @ruqsarkhanam4376
    @ruqsarkhanam43762 жыл бұрын

    Best videos and great content. Your doing a great job. Subscribed 😇

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks and welcome to the channel.

  • @mjespersgaard
    @mjespersgaard4 жыл бұрын

    Super cool trick, thanks a million. 👍

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Glad you liked it!

  • @knoxlam4909
    @knoxlam49092 жыл бұрын

    Simple and smart Thank you

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Glad to hear that. Thanks for watching.

  • @onesoldierserving
    @onesoldierserving4 жыл бұрын

    This is genius! Thank you!

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    You are so welcome!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Glad you liked it.

  • @nanogongolo
    @nanogongolo2 жыл бұрын

    very clean trick!!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    👍

  • @bobvos7680
    @bobvos76804 жыл бұрын

    Very helpful video, thanks. Up untill now I was always adding a new screen for security and had a bunch of text fields for front/back admins, etc.

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    This is a super useful hack. You can also add AD groups to a SharePoint group and use the same hack to see if user is part of the AD group.

  • @bobvos7680

    @bobvos7680

    4 жыл бұрын

    @@RezaDorrani I have AD Connect running with all the department groups already set up for our Intranet SharePoint Site. I Didn't think of that...will definitely check that out, it would save so much time. I've implemented your security trick this morning and it works great. Also for filtering a drop down menu. To get rid of the delegation warning I collected the Security list and work from there. Thanks again!!

  • @North2World
    @North2World9 ай бұрын

    So useful!

  • @RezaDorrani

    @RezaDorrani

    9 ай бұрын

    Nice to hear

  • @sanatan_dharam515
    @sanatan_dharam5153 жыл бұрын

    great videos and content brother..... Keep up the good work.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Appreciate it!

  • @conaxlearn8566
    @conaxlearn85662 жыл бұрын

    Pure genious!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    👍

  • @vinays4375
    @vinays4375 Жыл бұрын

    Superb and nicely explained

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks

  • @shannonfong9519
    @shannonfong95193 жыл бұрын

    Beautiful. Thank you

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you Shannon

  • @daxteoh27
    @daxteoh272 жыл бұрын

    Brilliant!

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks

  • @aaaaa601
    @aaaaa6012 жыл бұрын

    Thks Reza 🙋‍♂️❤👏👏👏

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    You are most welcome

  • @barunroyghatak4380
    @barunroyghatak43803 жыл бұрын

    Very nicely explained

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you

  • @StephanOnisick
    @StephanOnisick Жыл бұрын

    Great Video.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks!

  • @michelforro
    @michelforro4 жыл бұрын

    Nice approach!

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Glad it was helpful!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you

  • @arshiafirdous367
    @arshiafirdous3672 жыл бұрын

    Great video

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks!

  • @vedransehovic6321
    @vedransehovic6321 Жыл бұрын

    This is great, thank you Reza! How would you do this for the user that is not currently logged in. (ie. is user X part of an Admin group?)

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    kzread.info/dash/bejne/fGGcr6-Roq6zhqg.html

  • @josephdignam8576
    @josephdignam85763 жыл бұрын

    This is genius, I have implemented it and it works great. Do you expand on this video to show how to filter if you put list items in for multiple departments in the same list?

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Check kzread.info/dash/bejne/fGGcr6-Roq6zhqg.html

  • @pavithrabk6098
    @pavithrabk60984 жыл бұрын

    Great Video! I saw a few other videos which were in the direction of using Power Automate to check if user is present in a SharePoint group, but i think your approach saves us a call and is a better. Quick question: Would this have any performance related problem if we have a lot if people within the SharePoint group that i am checking ?

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Performance wise it would be the same with respect to breaking list item permissions in a SP list. The more users you have, the more checks it would need to make. I recommend creating an AD group, adding all users to that group and then add the AD group to the SP group. That ways it would require less manitenance on the SP side.

  • @mouctechy
    @mouctechy Жыл бұрын

    Thanks a lot for this great tip. In my case I have a sharepoint list of system owners and Through my app, I am performing CRUD on that list to add or remove owners however for the new owners to use the app, they must added to a sharepoint group. I would like to achieve this via power app when adding the owner maybe add checkbox to add him/her to the sharepoint group at the same time. Is that possible?? or any work around to achive this securely. Thanks!

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    I do not have a video reference on this scenario and would have to try it out to know its possibility. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @mouctechy

    @mouctechy

    Жыл бұрын

    @@RezaDorrani thanks

  • @user-uf4pv4lc9k
    @user-uf4pv4lc9k3 ай бұрын

    Thanks Reza, i was wondering why i am only getting solutions to check for O365 groups and not Sharepoint groups.My site is not connected to O365 so i was wondering what i am missing till you said it that there is indeed no direct way to access SP groups from canvas apps.

  • @RezaDorrani

    @RezaDorrani

    3 ай бұрын

    SP Groups is not understood by Apps

  • @user-uf4pv4lc9k

    @user-uf4pv4lc9k

    3 ай бұрын

    @@RezaDorrani yes indeed, thanks alot. Chcking O365 group linked to my team site does not help because still we cannot distinguish between Owners, members, visitors part of o365 group. So your solution is perfect for me.

  • @alaamohyeldin
    @alaamohyeldin4 жыл бұрын

    Great hack! Thaaaanks

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Thank you

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Most welcome

  • @MrSameeKunta
    @MrSameeKunta3 жыл бұрын

    Nice trick

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thank you

  • @kulwinderrehal2688
    @kulwinderrehal26882 жыл бұрын

    Thanks for this. I can do everything except removing owners from a list item access. It still keeps showing owners in the Manage Access option.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    I believe the Owners permissions is a default behavior in SharePoint.

  • @HinaGeo
    @HinaGeo2 жыл бұрын

    Thank you soooo much Reza! You are a brilliant MVP. Can you please guide me if instead of count we can check the title of the group?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Yes, you can check for title

  • @moetoledo
    @moetoledo9 ай бұрын

    Thank you Raza for a great workaround. It worked fine for me but I get an error message for non-admin users when lunching the app, even though the app works fine for them. The error message " Error when trying to retrieve data from the network: Access denied" and they only see their items as they suppose to. Any idea why this was happening?

  • @RezaDorrani

    @RezaDorrani

    9 ай бұрын

    I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @moetoledo

    @moetoledo

    9 ай бұрын

    @@RezaDorrani Thank you, I was able to solve it, it was because of the permission to the list.

  • @stefancochrane2723
    @stefancochrane27232 жыл бұрын

    Many thanks! What if one is required to email the list of people in one of these groups? I usually create a list of security groups, including members, and in flow, get the name of the users this way. How can one grab the users from the security group in flow?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    There is an Azure AD connector in flow that lists out group members.

  • @marianroca6329
    @marianroca6329 Жыл бұрын

    Genius

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Thanks 😊

  • @oraibabdulla
    @oraibabdulla Жыл бұрын

    I need to set a group of people with certain permission level to add items only without add/ create new view can you please advice ? thank you ,,, I already set a public default view with filtration of created by [Me] so every one with the link can only see his own items ... the thing is when I grant them the access on the level of permission I need they will not be able to open the list and they got request access page ! ... this is so wired please help! & when I give them directly a contribute permission they are able to create a view I need your advise please

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    I will recommend posting your scenario on forums at powerusers.microsoft.com

  • @avinash445
    @avinash44511 ай бұрын

    Brilliant! Looking for a workaround in pasting screenshots in rich text editor control.

  • @RezaDorrani

    @RezaDorrani

    11 ай бұрын

    Thanks! I am not aware of any options to do that. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @vivektiwary425
    @vivektiwary4253 жыл бұрын

    Awesome Explanation!! Need one help. In my case, i have used one SP list called “Owner”, in which 2 email id is present under “Title” who can access particular field in form but for other user fields display mode should be disabled. What code i should write

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    I would have to try your scenario out to give u the code. I would recommend you post your query with screenshots on the forums at powerusers.microsoft.com

  • @burakbektas190
    @burakbektas1903 жыл бұрын

    I am huge fun of you Reza.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Thanks.

  • @lisag2312
    @lisag2312 Жыл бұрын

    Great solution option! Will this also work for members of MS365 groups given access to the list item?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Yes, SP groups can contain security groups.

  • @greg2kdotcom
    @greg2kdotcom2 жыл бұрын

    Hi Reza. At 9:16 you can see that this user cannot see the list item you created, but can CREATE a new item . This would break the CountRows validation in the app wouldn't it? If the non-admin user knows the list URL and can create a new item, he would automatically have access to an item, and thus get a CountRows of at least 1. Would you break permission inheritance on the "Help Center Admins" list or is there another way?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Each list item is unique. You could use the ID column in SharePoint to only check for that specific list item. Even if user creates one, it would not be queried in the Power App. The video also shows a query being performed for a specific list item.

  • @user-vo8go7fl8j
    @user-vo8go7fl8j3 жыл бұрын

    Thank you for yor video! Can you advice, how to get members of SharePoint group in Power Apps?

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    This one really got me thinking. Getting members of a SharePoint group (specifically one that is not tied to an Office 365 group) is really interesting. I do have a solution and I think I will blog about it :) Stay tuned!

  • @oraibabdulla
    @oraibabdulla Жыл бұрын

    Hi, do I need to grant people access for the whole site in order to give them an access to a specific list ?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    You could grant access to a specific list.

  • @arvindeleon4527
    @arvindeleon45273 жыл бұрын

    Hi Reza. Just wondering, if the bug with DataSourceInfo function and Sharepoint as data source fixed as of now? Is it now possible to use? Thanks in advance. More powers!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    DataSourceInfo is still a known issue with SharePoint as of today.

  • @Bi-yf7zk
    @Bi-yf7zk Жыл бұрын

    is there a way to use the sharepoint group as the items of a combo box or a drop down box?

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    My guess is Yes by using flow to query SharePoint api and sending response back to power apps.

  • @Bi-yf7zk

    @Bi-yf7zk

    Жыл бұрын

    @@RezaDorrani thanks for the tip, but I decided to go with collection in app as it's a rather small group of people, still good to know. thanks a lot~

  • @lyonjinx730
    @lyonjinx7304 жыл бұрын

    Love the solution! I have an issue that a site owner not included in the SharePoint group can see the item in the list even though I have removed site owners from 'Manage access' list.. Perhaps someone could advice if Owner access is hidden somewhere else?

  • @RezaDorrani

    @RezaDorrani

    4 жыл бұрын

    Which site template are you using for SharePoint site - Communication or Team site? In a team site, the owners group are also site collection admins and hence they will have complete access on all artifacts.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    This scenario purely deals with SP groups which is handles the core security logic for Comm sites. For Team sites the security is managed via O365 groups. There is an O365Groups connector available where you can check if user is member of that group.

  • @shupriyamishra5681
    @shupriyamishra56812 жыл бұрын

    Sir Can we filter sharepoint choice field option according to the sharepoint group user in power apps? if possible please guide me

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Not sure. I have not come across this scenario. I will recommend checking on the forums at powerusers.microsoft.com

  • @rgmusic93
    @rgmusic933 жыл бұрын

    Hello Reza, Nice and simple video, I have little complex scenario, where there are 8 tabs for 8 different Groups in Org (i.e groups HR, Legal, etc..), need to implement the security using this approach, how to check this on App start?

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    You would have to repeat the logic 8 times on App start for each group

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    You would need to create 8 line items in the SP list and apply row level security. Then check each item on App start.

  • @rgmusic93

    @rgmusic93

    3 жыл бұрын

    @@RezaDorrani Thank you!! yes, I achieved this with row level security :)

  • @mardithpascua8112
    @mardithpascua81122 жыл бұрын

    Hello reza, is there a way to check if a current logged in user is a member of a SharedMailbox?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Not sure about that since I have not tried it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @sonalshinde5248
    @sonalshinde52483 жыл бұрын

    Hi Reza, Could you please tell me what to do if there are multiple items in security list?

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    You need to set the permissions for each item (item level permissions). Give each list item a unique Title. Query for the title in Power Apps to check if user is part of group.

  • @sonalshinde5248

    @sonalshinde5248

    3 жыл бұрын

    @@RezaDorrani thanks.. such a great video

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    @@sonalshinde5248 I would recommend you check this one also kzread.info/dash/bejne/fGGcr6-Roq6zhqg.html

  • @SirajAhmad-uo1gr
    @SirajAhmad-uo1gr3 жыл бұрын

    Hello sir, howyour logic will work if you are deciding only on count, and it will not work if you have more than 1 group.e.g: if you show some resources to one group, you add that group in LIST, but if you need to show some other resources to other group, you will have to add that group in LIST but you have to hide the first resources from groupB. than how could you handle it? it will also throw the count>0 for first resources

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Permissions are being assigned at an item level in the list. You can also use the Title column of the list to define the group. Item 1 - Title = Group A, item permissions only to Group A Item 2 - Title = Group B, item permissions only to Group B In Power App check for combination of Title and row count for each group.

  • @akkaradechsrithongchai7766
    @akkaradechsrithongchai77662 жыл бұрын

    While users (who was not admin and cannot access Security MS List file ) open the App on mobile phone , they will see warning massage pop on top screen like "something wrong with access/connection with the Security (ms)list file". Could we do to ignore or prevent the warning massage as mentioned ? Thank you.

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Not sure if I understood your question. Key is to give users read access to the list and break permissions at the list item level.

  • @akkaradechsrithongchai7766

    @akkaradechsrithongchai7766

    2 жыл бұрын

    @@RezaDorrani Yes , App is work properly but only Users always see warning massage popup once open the App. May I capture and send pic to you ?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    @@akkaradechsrithongchai7766 I world recommend to post the issue with screenshots on the forums at powerusers.microsoft.com

  • @cubii8126
    @cubii81262 жыл бұрын

    Great Work. Do you know how to retrieve the group members from a particular list items. For example, Employee list can access by person A and person B. Inside the Employee list has 2 items the first item can only access by person A. How can I get the members who can access the first item ?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thanks. You would need to call flow to query (using REST API) the users from the SharePoint group to get the members.

  • @indhujadurai7300
    @indhujadurai73002 жыл бұрын

    How to update a list when a user is added to a SharePoint group (by checking if the user exists or not) using Power Automate flow?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    You would need a trigger for user being added to a list. It would have to be via flow or some event trigger.

  • @indhujadurai7300

    @indhujadurai7300

    2 жыл бұрын

    @@RezaDorrani Thanks a lot Reza!

  • @sandeepkumar-rq2mk
    @sandeepkumar-rq2mkАй бұрын

    Hi Sir Reza, Can we check users belong to a particular SharePoint group via power apps directly ,without using power automate flows

  • @RezaDorrani

    @RezaDorrani

    Ай бұрын

    Does this video use power automate flow?

  • @sandeepkumar-rq2mk

    @sandeepkumar-rq2mk

    Ай бұрын

    @@RezaDorrani no sir, but i need in the scenario where the user is shared with app not with the site

  • @RezaDorrani

    @RezaDorrani

    Ай бұрын

    @@sandeepkumar-rq2mk You have to share the site or list with user in order for them to work with SharePoint data in power apps.

  • @BIlalKhan-te6ii
    @BIlalKhan-te6ii Жыл бұрын

    Cant I just check if the person is in the group or not, Why should I need to create a list and then create a restricted access item for this to achieve. There should be a way to directly access the group from powerapps.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Because there is no direct action to check if user is in SharePoint group within power apps.

  • @subsguts2691
    @subsguts26913 жыл бұрын

    This solution worked, sort of, but I have a problem. For a user that is not in the group that can't see the Security List it gives and error when I run the PowerApp every time. It gives the error when it tries to populate the IsAdmin variable. It does work if after you close the error message, but obviously I don't want every non-admin to see an error message everytime they run the application. Thanks for your help!

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    There should be no problem. Everyone should have read access to the security list. Key is to set item level permission on the list item. So when we check to see the item count within the list - it would return as 0 for users who dont have access to the list item.

  • @subsguts2691

    @subsguts2691

    3 жыл бұрын

    @@RezaDorrani Thanks for the really quick response. I'll re-watch the video and attempt get this set up correctly. As a side question, do you know if there is a way to check to see if a user has certain access to a SharePoint List? I saw another video suggesting to use the DataSource, but I believe you said this was worthless when SharePoint holds your data. Correct? Thanks again for the help and posting the video.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Subs Guts The DataSource object does not work for SharePoint. For checking a users access to a list you would have to do a little bit of error handling in case the user has no access.

  • @aeasignar
    @aeasignar3 жыл бұрын

    Hi Reza, I followed all your videos, can you please refresh if you have this kind of functionality, I have the following field and use case besides 1. people group field - contain multiple user accounts(display as name) 2. Textfield - logged user field(display as name) 3. Textfield1 - display the name here in this field if the logged user is present in the people group field Thanks and take care

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    I would have to try out your scenario to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @guggilamdivyasai3451
    @guggilamdivyasai34512 жыл бұрын

    Can't we do this by getting group members instead of using another list. I mean is there any reason why it won't work directly

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    To get group members, you would have to call a flow from Power Apps, use the http API to get group members and return that info back to Power Apps. The technique showcased in the video does not require flow.

  • @leenashreeindrani532
    @leenashreeindrani5323 жыл бұрын

    Hi Reza, This video helps a lot to find a way I would like to know how to define if I have multiple SharePoint groups Can you please share that.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Add multiple items in that hidden list. Trick is to add item level security to the list item.

  • @leenashreeindrani532

    @leenashreeindrani532

    3 жыл бұрын

    @@RezaDorrani Hi, I have done that. In powerapps how do I diferentiate that name as in a list it contains multiple items Eg: abc is a item and abc permission is given Xyz is another item and xyz permission is given Now on the app start how to add both Can you given an example of it If you have a video of it will be grateful to go through.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    @@leenashreeindrani532 Give a unqiue name to each item in the list. Then in Power App, use Filter(listname, Title ='item unique name') and then check its count.

  • @leenashreeindrani532

    @leenashreeindrani532

    3 жыл бұрын

    @@RezaDorrani Hi Reza, Thanks will check and let you know.

  • @leenashreeindrani532

    @leenashreeindrani532

    3 жыл бұрын

    Hi Reza, As suggested I have written as below Set(isAdmin,If(CountRows(Filter(Security,Title='Owner Group'))>0,true,false)); Though I am part of SharePoint groups it returns false. Can I get your number to contact on this please...

  • @tiasengupta4289
    @tiasengupta42892 жыл бұрын

    Great explanation! How can we remove all users from sharepoint group?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    You can manually do that from SharePoint group.

  • @ViktoriaTerzieva
    @ViktoriaTerzieva Жыл бұрын

    Hey is it possible sending an email from power apps to sharepoint group members

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    You would need to call flow to get group members

  • @hemlataharwani9404
    @hemlataharwani9404 Жыл бұрын

    Hello Reza..I have one requirement where I have to check user from 1st Approver Collection ....if user is from that collection then move to second approval code in powerapps.If user is from 2nd Approver Collection then no need to go for any approval code.

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    I do not have a video reference on this and will need 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.

  • @hemlataharwani9404

    @hemlataharwani9404

    Жыл бұрын

    @@RezaDorrani thank you for reply. I raised this question in PowerApps community also but didn't get any response from there.I figured out that I need to check user().email on Submit button of form to check whether the logged in user is from Approver collection or not but stuck at implementation because for other users with read permission powerapps code is working correctly but I need to alter for approvers(contribute permission).

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@hemlataharwani9404 Forums is a free platform. You may or may not get a response. You will need to wait patiently for a response. It could take days or weeks. If it’s urgent, then you may need to look at getting consulting help.

  • @hemlataharwani9404

    @hemlataharwani9404

    Жыл бұрын

    @@RezaDorrani yes I am waiting for the reply and researching as well actually I am beginner in powerapps and doing this for learning purpose...thank you for all the videos..they are great help.

  • @Himanshunayyar12
    @Himanshunayyar122 жыл бұрын

    Hi, How to handle this for more than one group?

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Each group would be a new item in the SharePoint List.

  • @DHPMeditations
    @DHPMeditations3 жыл бұрын

    Wow! I guess I am the only one this doesn't work for. I followed this to the letter. I created a new list and added the name of the User Group in the title. I then added only those individuals, including myself, to the user group. I then created unique permissions on the list and remove all the other user access groups (unfortunately this is a sub site and so the Site admins also have access and I cannot test this because I am a Site Collection Admin) . The Long and short of this is... When I go my SharePoint Power Apps form (custom form for SharePoint List) and add the date source, and put the function in the SharePointIntegration start, I get 'false' for isAdmin. I have refreshed the data, and rerun the start, still false for me. I am in this group, I can see the item in the table, it should be true.

  • @kwilliams1130

    @kwilliams1130

    3 жыл бұрын

    I am having a similar issue. I stead of showing the button for an Admin, I am hiding an Edit button to Visitors. I switched the true and false, but the Visitor is still seeing the button.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Tested this on a subsite and it works fine. Followed the steps in the video and got it to work. Make sure the list item you create in the list has permissions broken and security setup correctly.

  • @RezaDorrani

    @RezaDorrani

    3 жыл бұрын

    Tested this on a subsite and it works fine. Followed the steps in the video and got it to work. Make sure the list item you create in the list has permissions broken and security setup correctly.

  • @arvindeleon4527
    @arvindeleon45278 ай бұрын

    Hi Reza, does this still work to date??

  • @RezaDorrani

    @RezaDorrani

    8 ай бұрын

    Yes it does

  • @palikaanusha3043
    @palikaanusha3043 Жыл бұрын

    I need sharepoint current site grops, not users

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    Videos shows how to check if user is part of a sharepoint group. What is your scenario?

  • @palikaanusha3043

    @palikaanusha3043

    Жыл бұрын

    Should check the user belongs to which group in a particular site and if I want to give access then add that user into particular SharePoint group, If I want to revoke that user then I should remove in that particular group

  • @RezaDorrani

    @RezaDorrani

    Жыл бұрын

    @@palikaanusha3043 I do not have a video reference on this scenario. You would probably need to use flows to do all this. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com

  • @palikaanusha3043

    @palikaanusha3043

    Жыл бұрын

    @@RezaDorrani Thank you Reza, You are such a very kind & responsible person.

  • @osvaldopedrozo4838
    @osvaldopedrozo48382 жыл бұрын

    Hello everyone

  • @RezaDorrani

    @RezaDorrani

    2 жыл бұрын

    Thats my opening line 😁

  • @SamiNord
    @SamiNord10 ай бұрын

    Very complicated for me.

  • @RezaDorrani

    @RezaDorrani

    10 ай бұрын

    Apologies. Check on forums in case someone has a simpler workaround powerusers.microsoft.com

  • @KyleMSchroeder
    @KyleMSchroeder4 ай бұрын

    I know this video is old, but you should avoid teaching "If( someCondition, true, false)". Instead, you should just have this: Set(isAdmin, CountRows(Security) > 0). This is cleaner and teaches people to better understand booleans.

  • @RezaDorrani

    @RezaDorrani

    4 ай бұрын

    This was done years ago. Check patterns in my newer videos.