Gallery Data from Two Sources

(0) Share

Report

Posted on by RJF61

1,265

I have a gallery based on the following...

In a related list VehList, I have a description column/field named "VehMfgMod" for each of the ID numbers shown under the yellow arrows (i.e., 2, 9, 34, 35, etc.). Is it possible to identify and bring those values into the Gallery - Items. I would like to include within the red circled area.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RJF61 ,

I may not have interpreted your requirements exactly here, but from your description, are you trying to do this ?

Sort( AddColumns( VehNoList, "Model", LookUp( VehInsp As aVeh, aVeh.VehNo.Value = VehNo.Value ).VehMfgMod ), CurrentMileage, Descending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @WarrenBelz thanks for the reply. My question is do I need to modify the LookUp to VehList versus VehInsp? VehList contains the vehicle info (VehMfgMod) and VehInsp contains the inspections by vehicle.

Sort( AddColumns( VehNoList, "Model", LookUp( VehInsp As aVeh, aVeh.VehNo.Value = VehNo.Value ).VehMfgMod ), CurrentMileage, Descending )
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RJF61 ,

It depends which "base" you want to display and subsequently which columns you need to add from the "other" list. You can do it either way (adding the missing columns by referring to the matching VehNo.)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ok got that to work but lost the Distinct/Grouping for the individual VehNo.