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

[carl1to]

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?

[carl1to · Accepted 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>

[rampprakash]

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