web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter based on relate...

Power Apps

Answered

Filter based on related table (Expand Query for List Rows)

(0) Share

Report

Report

Posted on by carl1to

208

I would like to get all users of my Environments Group Team in a cloud-flow.

I tried the approach as explained here: https://powerusers.microsoft.com/t5/Using-Flows/Get-Team-Members-of-TEAM-Typ-Owner-in-CRM-dynamics-365-using/m-p/1374653/highlight/true#M27429

(vTeamNameKL is a string variable containing the name of the Group Team)

The results are not filtered, all users are returned, even if they are not assigned to a team.

Does somebody know whats wrong?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

carl1to 208 on at

Like (1)

Report
Update: found an alternative for this
https://crmkeeper.com/2019/08/31/cds-list-records-filter-query-using-flow/

Use FetchXML:

<fetch top="1"> <entity name="systemuser"> <link-entity name="teammembership" from="systemuserid" to="systemuserid" link-type="inner" intersect="true"> <link-entity name="team" from="teamid" to="teamid" intersect="true"> <filter> <condition attribute="name" operator="eq" value="TeamName" /> </filter> </link-entity> </link-entity> </entity> </fetch>

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hello @carl1to,

Both Filter Query and FetchXML perform same operation with a milliseconds difference. Its good you have found a solution 🙂

Please mark your solution as Completed so that others can fix it.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No

Join the conversation