How to set a lookup field with multiple values

[jpr23]

Hi 

Hi , 

i have a list of code and i want to update an element with multiple values.

Can you help me on the good syntax to do this  ?

List 

Update element

Solution

use an array variable .

Initialize an array variable like this ...

Syntax  for example 

[
{
"Id": 44
},
{
"Id": 47
}
]

or and add dynamiquely the ID's of the items you want  in the array variable ( add to an array ..) with the "id":  prefix.

Thanks...

[HenWang · Accepted solution]

Hi @jpr23 ,

Yes, exactly, and for more detailed steps, you can refer to my previous answer:

Solved: Re: Merge Values From 3 Lookup Columns Into Anothe... - Power Platform Community (microsoft....

Best Regards,

Hen Wang

[jpr23 · Accepted solution]

Thanks for your answers.

Here is the final solution i put in place . It is more complex than a simple affectation of values because we have initally a choice field with multiple values of "application code"  and we want to copy theses values in a lookup field based on a sharepoint Application list . 😰

So i have to read an Array of values , to search the occurrence of each value in the Application list to catch the ID , to  put the result  in an array of ID and finaly to put the ID array in the lookup field .

1. Initialise an ID array variable if the whole treatment is in a higher loop 

1. Select the source choice field values by  a select action

1. Add a loop apply to each value of the select output and get elements in the Application list to obtain the ID's

And then for the value read in the Application list , read the ID part of the array and add this in an id array

In the end , you have to use an update element action to  put the ID Array in the lookup field of the list …

( in array mode)

Victory ! 😀