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.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,289)