Canvas App using Dataverse for Teams - Group Membership

[CH007]

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

[BCBuizer · Accepted solution]

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
        )
    )

[CH007]

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]

Hi @CH007 ,

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