Announcements
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?
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>
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/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 93 Most Valuable Professional
Haque 81
Valantis 49