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-3...
(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?
Solved! Go to Solution.
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>
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/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
15 | |
10 | |
7 | |
4 | |
3 |
User | Count |
---|---|
23 | |
15 | |
13 | |
9 | |
9 |