Power Platform Community Forum Thread Details

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?

Categories:

General Questions

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')