Power Platform Community Forum Thread Details

Hi,
For starters, I apologize if this question has been posted and answered before. I did my best searching for it, without the right results so far.

I have this custom project entity. I related it to systemuser with a N:N relationship in order to compose a project team.

In my canvas app there is a dropdown in which I need only the projects that I'm related to according to this project team relationship. I just can't seem to find out how to construct the filter for the items correctly.

The Fetchxml for the filter would be fairly easy:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true" no-lock="false">
	<entity name="dh_project">
		<attribute name="dh_name"/>
		<link-entity name="dh_project_systemuser" from="dh_projectid" to="dh_projectid" visible="false" intersect="true">
			<link-entity name="systemuser" alias="aa" from="systemuserid" to="systemuserid">
				<filter type="and">
					<condition attribute="systemuserid" operator="eq-userid"/>
				</filter>
			</link-entity>
		</link-entity>
		<attribute name="dh_projectid"/>
	</entity>
</fetch>

but I guess that's of no good use.

Any ideas on how to get the items filter correctly?

Thanks for thinking along with me.
Regards,
Jeroen

Categories:

Building Power Apps