Having trouble joining 2 datasources using the LookUp function

(0) Share

Report

Posted on by bobgodin

380

@WarrenBelz I have a Sharepoint list called Trips and a collection called colTripData (based on the TripDetails list) - both have the field tripid amd I am trying to join them in the Items property of a Gallery so I can filter on the field region which is in the Trips list only. I want to have the region field equal to the value of a variable called varRegion which I have already set.

Here is the code I have tried on the Items property of the Gallery:

SortByColumns(
 With(
 {_details: colTripData},
 Filter(
 _details,
 LookUp(
 Trips,
 tripid = tripid
 ).region = varRegion
 )),
 "tripdate"
 )

it comes back with "Error when trying to retrieve data from the network"

what am I doing wrong? thanks...

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bobgodin ,

Please try:

ForAll( Trips, Patch(ThisRecord,LookUp(colTripData,tripid=Trips[@tripid])) )

Best Regards,

Bof

Was this reply helpful? Yes No