Nested LookUp among 4 tables.

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I want to get ProductTypeId of the ProdType table from a gallery in which the data source is the Complaint table. How can get that?
Thank You.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share more details about your scenario? What is your data source, Dataverse or anything else? If it's Dataverse, then you will be able to get the ProductTypeId quite easily. So, you have a Gallery that Items is the Complaint table, and if you want to display ProductTypeId on a Label in the Gallery, the formula for Text property of this Label is:

ThisItem.PurchaseId.ProductID.ProdTypeID.ProdTypeID

Best regardes,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni,
Thanks for your response.
It's showing an error. Multiple levels of many-to-one relationship expansion aren’t supported.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @Anonymous ,

Can you try the following code?

With( { //Assuming Complaint Table is stored as Gallery on screen. Textbox is also fine, replace if needed ProductLookUpID : If(!IsBlank(ThisRecord.Purchase), LookUp(Purchases, PurchaseID = ThisRecord.PurchaseId, ThisRecord.ProductID), Blank()) }, With( { ProductTypeLookUpID: If(!IsBlank(ProductLookUpID), LookUp(Product, ProductID = ProductLookUpID, ThisRecord.ProdTypeID), Blank()) }, If(!IsBlank(ProductTypeLookUpID), UpdateContext({varProdType: LookUp(ProdType, ProdTypeId = ProductTypeLookUpID, ThisRecord.ProdTypeName) }), UpdateContext({varProd: Blank() }) ) ) );

Please make field changes and column name wherever required.
Hope this helps

Was this reply helpful? Yes No