Power Platform Community Forum Thread Details

Hello,

I cannot find a solution to the following scenario and am looking for help.

I have three tables:

Table 1 = Location

Table 2 = Pricing Request

Table 3 = Pricing Location

The Pricing Location is a custom N:N relationship with three fields:

Location
Pricing Request
Pricing Location (Primary Key)

I have embedded a canvas app on the Pricing Request entity with the intention for users to create pricing locations easily and quickly. The Location and Pricing Request entities both have a required lookup to the Account table called Customer.

The following filter is not working in my embedded canvas app, and I cannot figure out why:

Filter(
LookUp(
'Pricing Requests',
'Pricing Request' = [@ModelDrivenFormIntegration].Item.'Pricing Request'
).Customer.Locations,
Not(
Location in LookUp(
'Pricing Requests',
'Pricing Request' = [@ModelDrivenFormIntegration].Item.'Pricing Request'
).'Pricing Locations'.Location.Location
)
)

Any ideas? Is this simply too complex of a query?

Categories:

Building Power Apps