Answered

Collect on a lookup column is not setting the lookup column

(0) Share

Report

Posted on by EG-04061836-0

I'm progressing on my endeavor to learn PowerApps and I have been working on the sample Expenses template. I have remade the built-in sample collections to SPLs. Im having trouble with the NewLineItem Screen, on the button fx, I do not show an error but when I click the button after adding data, it works properly and data is addded to the SPL, however the lookup column "ReportID" is not being populated.

Can anyone help me understand what is happening?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,717 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @SparkleTex ,

You need to specify the field from Expenses2 that is to be populated into ReportID.

LookUp( Expenses2, ID = SelectedReport2.ID ).YourReportIDField

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
EG-04061836-0 7 on at

Like (0)

Report
Copy link

Link copied!

That got me there! Thank you!

ReportID: {
Id: LookUp(
Expenses2,
ID = SelectedReport2.ID
).ID,
ID: SelectedReport2.ID
}

Was this reply helpful? Yes No