Adding data from a lookup to a collection

[arturdjali]

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

[BCBuizer · Accepted solution]

HI @arturdjali ,

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
		)
	)
)