Answered

Trying to add a column to a collection

(0) Share

Report

Posted on by bobgodin

380

I have the following code which creates a collection from a Sharepoint list called TripDetails - it filters on the date being Today and 5 days into the future - this working fine:

ClearCollect(
 colTripData,
 With(
 {
 StartDate: Today(),
 EndDate: Today() + 5
 },
 Filter(
 TripDetails,
 tripdate >= StartDate,
 tripdate < EndDate
 )
 )
);

I need to get the region field into that collection but it is in a different Sharepoint list called Trips so I need to do an AddColumns with a LookUp on tripid which is in both lists and then return the region field - I think the code is similar to this :

AddColumns(
 Trips,
 "Region",
 LookUp(
 colTripData,
 tripid exactin Trips.tripid
 ).region
)

- can someone tell me how I wrap that code around my existing ClearCollect please - I have tried many combinations but none have worked for me yet...thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi @bobgodin ,\

You can put the AddColumns at the bottom too if you want - neither place is Delegable. I also assumed the field name in your other list.

With( { StartDate: Today(), EndDate: Today() + 5, Data: AddColumns( TripDetails, "Region", LookUp( Trips As aTrip, aTrip.tripid = tripid ).Region ) }, Filter( Data, tripdate >= StartDate, tripdate < EndDate ) );

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

Was this reply helpful? Yes No
bobgodin 380 on at

Like (0)

Report

hi @WarrenBelz thank you that did the trick!

Was this reply helpful? Yes No