Adding data from a lookup to a collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I would like to do a lookup on each item in the item collection and add the result of the lookup to a column in the collection. I am still all new to this, but i am not sure how to go about it or if this is the best way.

this is as far as i have gotten without much luck.

Collect(Test1,Filter('List', Ref = Text(ThisItem.ID)));
ForAll(AddColumns(Test As ThisExportToPDF, "GLCodes", LookUp('List that contains requied data',Title = ThisExportToPDF.ExpenseType)))

Any help is appreciated.

Thank you

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Anonymous ,

You seem to be a very long way there:

ClearCollect( Test1, AddColumns( Filter( Test, Ref = Text(ThisItem.ID) ) As ThisExportToPDF, "GLCodes", LookUp( 'List that contains requied data', Title = ThisExportToPDF.ExpenseType ) ) )