Power Platform Community Forum Thread Details

In my app I am trying to display a list of brands in a gallery with a list of retailers for each brand in a nested gallery. Each retailer also has an amount tied to it.

I have a single column SharePoint list that contains all the retailers. (In my code, this list is altered a little to get rid of the hidden SharePoint columns).

I have another list where all of the data is stored, once written to. The relevant columns are in this screenshot:

In my app I have a temporary collection that I read and write to before submission. This collection is updated with information whenever the value of the department dropdown changes.

The code for the OnChange of that dropdown:

ClearCollect(
 DepartmentBrands,
 Filter(
 ShowColumns(
 Brands,
 "Title",
 "Brand"
 ),
 Title = TV2.Department
 )
);
ClearCollect(
 Collect2,
 AddColumns(
 DepartmentBrands,
 "Retailers",
 AddColumns(
 ShowColumns(
 RenameColumns(
 Retailers,
 "Title",
 "Retailer"
 ),
 "Retailer"
 ),
 "Amount",
 LookUp(
 DataByBrand,
 Title = TV.Department && Brand = Brand && Retailer = Retailer
 ).CurrentAmount,
 "Parent",
 DepartmentBrands[@Brand]
 )
 )
)

Sorry if it's a little sloppy (if you have any suggestions about that, please let me know).

The error arises from the LookUp Function, more specifically "Retailer = Retailer" This is a placeholder because I do not know how to correctly call the column "Retailer" from the nested table, "Retailers".

With everything I have tried, I have gotten the runtime error, "The Requested Operation is Invalid. Server Response: DataByBrand Failed: Fetching Items Failed."

How do I correctly call the data? Thank you in advance.

Categories:

Building Power Apps