cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
carl1to
Helper II
Helper II

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

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... 

 

carl1to_0-1640251158514.png

(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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
carl1to
Helper II
Helper II

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>

 

 

View solution in original post

2 REPLIES 2
carl1to
Helper II
Helper II

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
Super User
Super User

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,028)