Help pulling data from Sharepoint Lookup Column

(0) Share

Report

Posted on by rosscortb

196

Hello,

I have added a table which is returning a collection that looks at a Sharepoint List. In that sharepoint list I have some lookup columns bringing data from a second sharepoint list. One of those columns is payroll no, which is returning [object Object].

Current Code is

ClearCollect(POrders,ShowColumns('Shopping Cart Order Items',"OrderID","Product","PointsQuantity","Total_x0020_Points","SalesQuantity","Total_x0020_Price","Employee_x0020_Lookup_x003a_Empl"))

So, I 've been trying to bring the value through with a lookup, not sure if this correct.

ClearCollect(POrders,ShowColumns('Shopping Cart Order Items',"OrderID","Product","PointsQuantity","Total_x0020_Points","SalesQuantity","Total_x0020_Price",AddColumns('Shopping Cart Order Items',"Payroll No",LookUp('Shopping Cart Order Items',"Employee_x0020_Lookup_x003a_Empl" =DataCardValue2.Text,'Payroll No'))

Any ideas the correct way to do this?

Thanks

Ross

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!
If you just want to bring in the Payroll number as a text field, not as a record, you will need to add a column like this.

ClearCollect(POrders,AddColumns('Shopping Cart Order Items',"PayRollNoValue", 'Payroll No'.Value))

I removed your show columns formula for simplicity, but you can add those back if needed.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt
rosscortb 196 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anchov Thanks for your help