cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CH007
Regular Visitor

Canvas App using Dataverse for Teams - Group Membership

Hi all,

I am building a canvas app which is using Dataverse for Teams for storage.

 

Within the app I need to know which group the user belongs to (relating to the team).

i.e. the Team has the following groups:

  • Owners
  • Members
  • Guests
  • Colleagues with Access

I would like to know how you lookup from within the app for example:

  • User 1 is in the Members group
  • User 2 is in Colleagues with Access

Any help with this would be greatly appreciated

 

Thanks

 

 

3 REPLIES 3
BCBuizer
Super User
Super User

Hi @CH007 ,

 

The below formula returns true in case the current users is in the Users table. Raplacing Users with the name of any other table will check if the current user is in that table, so can be used for the checks your are asking about.

 

    !IsEmpty(
        LookUp(
            Users,
            User().Email = Email
        )
    )


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Thanks @BCBuizer.

In your example you are referencing the Users table, is this only available with Dataverse or can this be accessed when using Dataverse for Teams also?

 

Thanks

 

BCBuizer
Super User
Super User

Hi @CH007 ,

 

I used the Users table indeed, but whatever table you have, you can use.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,455)