cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerAddict
Super User
Super User

CDS Opportunity Can't Access Price list Field

Hey all, this was a question that was asked a few days ago but for some reason, the correct answer wasn't marked as one. I don't typically do this but I am reposting this here with the answer so someone with the same problem can find the right solution.

I am trying to access the Price List field from an opportunity using a Model Driven Form app. I am attempting to access it like this.

Filter('Price Lists', 'Price List' = GUID(First([@ModelDrivenFormIntegration].Data).ItemId)).'Price List'

In accordance with what I read here.

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embedded-canvas-app-guidelines

However it doesn't seem that the @ModelDrivenFormIntegration contains the Price List data even though one is specified on the record. Anybody know where I am going wrong?
1 ACCEPTED SOLUTION

Accepted Solutions
PowerAddict
Super User
Super User

Ok, so relational data in an embedded canvas app has always been an issue (posted by me on one of my blogs: https://thepoweraddict.com/overcoming-5-top-challenges-with-embedded-canvas-apps/

 

Anyway, this is how you can make it work.

 

I have 2 screens in my app:

 

2. Screen 2: has a gallery of Opportunities (Gallery1) with the Items property set to Filter(Opportunities, Opportunity = [@ModelDrivenFormIntegration].Item.Opportunity) and (optional) I also have a label within the gallery that displays ThisItem.'Price List'.Name

 

1. Screen 1: has a gallery of Price Lists (Gallery2) with the Items property set to Filter('Price Lists', 'Price List' = First(Gallery1.AllItems).'Price List'.'Price List')

 

 

View solution in original post

1 REPLY 1
PowerAddict
Super User
Super User

Ok, so relational data in an embedded canvas app has always been an issue (posted by me on one of my blogs: https://thepoweraddict.com/overcoming-5-top-challenges-with-embedded-canvas-apps/

 

Anyway, this is how you can make it work.

 

I have 2 screens in my app:

 

2. Screen 2: has a gallery of Opportunities (Gallery1) with the Items property set to Filter(Opportunities, Opportunity = [@ModelDrivenFormIntegration].Item.Opportunity) and (optional) I also have a label within the gallery that displays ThisItem.'Price List'.Name

 

1. Screen 1: has a gallery of Price Lists (Gallery2) with the Items property set to Filter('Price Lists', 'Price List' = First(Gallery1.AllItems).'Price List'.'Price List')

 

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,259)