Answered

Trying to Retrieve User Infor and teammembership_association is Always Empty in Canvas App

(0) Share

Report

Posted on by dallenap

155

Exactly what the title says. I have a canvas app and I'm attempting to retrieve the team membership for the current user. For whatever reason, the team membership and security roles are always blank. The user has been assigned to teams and security roles. The admin clearly shows the user as a member of the team in the environment.

fxUser = ShowColumns(
    LookUp(
        Users,
        domainname = fxUserEmail
    ),
    User,
    'User Name',
    'Last Name',
    'First Name',
    'Full Name',
    teammembership_association
);
 
This returns blank:
LookUp(Teams,'Team Name' = First(fxUser.teammembership_association).'Team Name').'Team Name'
 
Any advice would be greatly appreciated.
 
Kind regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

vipuljain03 657 Super User 2025 Season 2 on at

Like (1)

Report
The Users data source in Power Apps often doesn't automatically expand related tables like teammembership_association. It retrieves the basic user information, but the related team memberships are fetched separately.

Solution:

Expand the teammembership_association column in your Lookup function - Use Expand within your Lookup to explicitly include the related team membership data.

fxUser = ShowColumns( LookUp( Users, domainname = fxUserEmail, {Expand: "teammembership_association"} // Key addition: Expand the related table ), User, 'User Name', 'Last Name', 'First Name', 'Full Name', teammembership_association ); // Now this should work: LookUp(Teams,'Team Name' = First(fxUser.teammembership_association).'Team Name').'Team Name'

It tells Power Apps to retrieve the related team membership data along with the user information.

---------------------------------------------

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,
Vipul

Was this reply helpful? Yes No
Verified answer

dallenap 155 on at

Like (0)

Report
That code does not work either. The ShowColumns throws an error message that the specified columns don't exist.

fxUser = ShowColumns( LookUp( Users, domainname = fxUserEmail, {Expand: "teammembership_association"} // Key addition: Expand the related table ), User, 'User Name', 'Last Name', 'First Name', 'Full Name', teammembership_association );

Also, I cannot find any documentation on the "Expand" in a LookUp. Where does one find this?

This, however, does appear to work:

fxIsInTestTeam = CountRows(

Filter(

ShowColumns(

LookUp(

Users,

'User Name' = fxCurrentUser.userPrincipalName

).'Teams (teammembership_association)',

'Team Name'

),

"Test Team" in name

)

) > 0

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Never seen Expand in Lookup only in Microsoft Graph. Your new approach is the correct approach.

Was this reply helpful? Yes No