Get value of lookup field in collection

(1) Share

Report

Posted on by Rosie

301

I am wanting to create a collection based on a dataverse table.

I have created views, but these don't seem to be very easy to use in this circumstance. I was able to return the entire set of columns but the lookup fields didn't have any values.

I have been trying ShowColumns to get the few column values I need from the table 'QPContainers'. I strike an issue with a column called 'Location' as it is a lookup column to a table called 'QP Location'.

This worked to get a list of containersIDs

Collect(
 cltPickUpView,
 ShowColumns(
 Filter(QPContainers, PickUpDT = Blank()),
 "qp_containerid"
 )
)

I thought addColumns might be required here but I can't figure out how to use it.

Any help would be appreciated.

Thanks

Rosie

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Rosie ,

I made a sample for you.

ShowColumns(AddColumns(TestL16,"related table's primary name column value",Test_LookUp.Name),"name","related table's primary name column value")

Best Regards,

Wearsky

Was this reply helpful? Yes No
Rosie 301 on at

Like (0)

Report
Copy link

Link copied!
Hello,
Thanks for your help, but this hasn't worked for me.
Also I still need to filter the data by the PickupDate and I am a bit unsure where to fit that into ShowColumns and AddColumns.

When I follow what you have I still only get the Container ID column, no Location column.

ClearCollect(cltPickUpView, ShowColumns( AddColumns( QPContainers,"LocationN",qp_Location.'Location Name' ), "qp_containerid" ) );

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Rosie ,

Try this:

ClearCollect(cltPickUpView, ShowColumns( AddColumns( Filter(QPContainers, PickUpDT = Blank()),"LocationN",qp_Location.'Location Name' ), "qp_containerid", "LocationN" ) );

Best Regards,

Wearsky

Was this reply helpful? Yes No
Rosie 301 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much.
I did make some progress with getting the LocationN in there - didn't quite follow your example - my apologies.
Thanks so much for adding the Filter section. I will give that a go now.
Many thanks
Rosie

Was this reply helpful? Yes No
Rosie 301 on at

Like (0)

Report
Copy link

Link copied!
This is what I ended up with. Two collections to filter the first collection without delegation warnings.
ClearCollect( cltPickUpByPickUpDT, ShowColumns( AddColumns( Filter( QPContainers, PickUpDT = Blank() ), "LocationN",qp_Location.'Location Name'//lookup field to another table ), "qp_containerid", "qp_bookingnumber", "LocationN", ) );//gets all container without a pick up date ClearCollect( cltPickUpView, Filter( cltPickUpByPickUpDT, qp_containerstatus in "Located" && qp_type in "Fit to Order" ) );//Filters the collection cltPickUpByPickUpDT to those that are Located and Fit to order types.

Was this reply helpful? Yes No
Thami on at

Like (1)

Report
Copy link

Link copied!

Struggled with my criteria and proposal evaluation Dataverse lookup, adding AddColumns worked!!!! Thank you very much.
ClearCollect(
colEvaluationDetails,
ShowColumns(
AddColumns(
Filter(
'Evaluation Details',
'Proposal Evaluation ID'.'Proposal Evaluation Description' = varSelectedProposalEvaluationID
), "Criteria",'Evaluation Criteria ID'.'Criteria Name', "Proposal Evaluation", 'Proposal Evaluation ID'.'Proposal Evaluation Description'),
"ndagrf_comments",
"ndagrf_criteriamaxscore",
"ndagrf_evaluationdetailsid",
"ndagrf_evaluationscore",
"ndagrf_name",
"Criteria",
"Proposal Evaluation"
)
);

Was this reply helpful? Yes No