Patching Multiple Records to Dataverse Lookup Field

[andycreigh]

I'm sure this is easy but struggling to get my head around it.

All tables set up in Dataverse.

CONTRACTOR - This is where al the contractor names are stored

QUOTES - this is the table I want to create records with a lookup to the contractor table.

There is a lookup Column from the QUOTES table to the CONTRACTOR TABLE

In my canvas app I have a Listbox called 'contractorlist' this has CONTRACTOR set as its items so it gives me a list of Contractors.

I want to create a new line in the QUOTES table for every contractor selected in the contractorlist

I have tried this and it will create the correct number of items but the Lookup column always repeats the first item in the list.

ForAll(ContractorList.SelectedItems.CONTRACTOR_NAME,Patch(QUOTES,Defaults(QUOTES),{QUOTE:"TEST",QUOTE_CLUB:Dropdown7.Selected,QUOTE_EXTRA_DETAIL:TextInput3.Text,QUOTE_EXPIRY:DatePicker1.SelectedDate,QUOTE_CONTRACTOR:ContractorList.Selected}))

The 3rd column below shows the output. I want it to create the correct lines but lookup to each of the Contractors on the listbox not just pick the first one it finds. Some sort of nested Forall?

[v-xiaochen-msft · Accepted solution]

Hi @andycreigh ,

According to your description, I've made a test for your reference:

1\ I have two tables. They are 'Students' and 'Head teacher'. 'Students' table has a lookup column: 'Head teacher'.

2\ Add a combo box control 'ComboBox2' and set its Items property to:

Choices(Students.'Head teacher')

3\ Add a button control and set its onselect property to:

ForAll(Sequence(CountRows(ComboBox2.SelectedItems)),Patch(Students,Defaults(Students),{Id:"5555555555555555555",'Head teacher':Last(FirstN(ComboBox2.SelectedItems,Value))}))

4\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[andycreigh]

Amazing Thank you. It Works!!

Great start to my Monday.

[Powerappsdev2]

Hi @v-xiaochen-msft ,

  I have similar requirement please help to achieve requirement.

Gallery items=projects.

Inside gallery.project name,Task name,price=textinput, combobox=items=users.

Input like below

galley rows like below

Project name=Abc ,task name=abc,Users=zennifer,Melon

Project name=Abc ,task name=xyz,Users=blank

Project name=Abc ,task name=efg,Users=sadvin,IT User

Project name=Abc ,task name=numbers,Users=blank.

Output like below

Project name  task name       Users

Abc                   abc                zennifer

 Abc                    xyz                zennifer

Abc                     efg                zennifer

Abc                    numbers        zennifer

 Abc                   abc                Melon

 Abc                    xyz                Melon

Abc                     efg               Melon

Abc                    numbers       Melon

Abc                   abc                sadvin

 Abc                    xyz                sadvin

Abc                     efg                sadvin

Abc                    numbers        sadvin

 Abc                   abc                IT User

 Abc                    xyz                IT User

Abc                     efg               IT User

Abc                    numbers       IT User

Please help to achieve above requirement.

Thanks in advance for quick respond....!!