News and Announcements icon

Power Platform CommunityForums Power Pages - Customize & Extend Filter Lookup bases on...

Power Pages - Customize & Extend

Suggested answer

Filter Lookup bases on N:N relationship

(0) Share

Report

Report

Posted on by Amine Amine

2

HEllo ,

I have a 4 tables :
Product table (virtual table from SAP)

Contact table (standart table)
Contact-Product (Contains the contact and product information as I cannot create N:N relationship for virtual tables)

In another table called Item I have a lookup to Product , so it shows all the products,

I want to filter this lookup to show only the product the user have access to based on the Contact-product table

How I acheive that, I dont want to create relationship between Contact-product and Item , because the contact product it's not used in the SAP,

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

SaiRT14 1,827 on at

Like (0)

Report

Filter Lookup bases on N:N relationship

Pls try the following:

In your Item lookup's View definition, use FetchXML to filter products based on the current user's access:

<fetch>
<entity name="product">
<attribute name="productid" />
<link-entity name="contact_product" from="productid" to="productid" link-type="inner">
<filter>
<condition attribute="contactid" operator="eq" value="@UserId" />
</filter>
</link-entity>
</entity>
</fetch>

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 144,858

#2

RandyHayes 76,287

#3

Pstork1 64,505

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans