How to patch multiple lookup selection from 1 list to another

(0) Share

Report

Posted on by lukegatt

149

I have list 1 which is a list of cost centers.

I have list 2 which is used to store contract data, this list has a lookup column to list 1, it is important to note that multiple selections is enabled.

I have a power app and a form linked to list 2. In the Cost Centre field generated from the form the drop down selections only give the number, this is not suitable for the end user.

Is there anyway I can show the CC name from list 1 in the drop down?

If I change the source of the Cost Centre field to list 1 I get the desired input layout however the data does not save to list 2 on submit.

I have tried numerous ways to patch the data but it is not working for me.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lukegatt,

Well, if you want to get the name, you should set the CC Name as the source column instead of the Title column.

Was this reply helpful? Yes No
lukegatt 149 on at

Like
a
(0)

Report
Copy link

Link copied!

If possible I would like both (name and ID using the double option in field settings) like in my last image but I am only getting "value"

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @lukegatt,

Not that possible, CC Name is additional column, you could not append it to ComboBox with a LookUp column.

A LookUp column contains Id and Value, Id is the ID from your list1, and Value is the Title from your list1, generally, we recgonize the Value as primary field of a LookUp fields populated in a ComboBox.

In a word, your opinion is undoable, we could only operate on a Value field if you populate ComboBox with a LookUp column.

A simpler way is to connect the list1 cost centers to this ComboBox, but configure the Update property of this data card as below:

ForAll( ComboBox1_1.SelectedItems, { Id: ID, Value: Title } )

Was this reply helpful? Yes No
lukegatt 149 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No