Update lookup column with value another column

(0) Share

Report

Posted on by skindu

121

I have a list of students with several columns, one of which is the STUDENT CODE with the same PT5023 pattern.

I imported about 4000 records from an excel file into a new Sharepoint list, in this list there is a field with the name CODE STUDENT with the same pattern (PT5023). In this second list I added a lookup column with the name STUDENT to the STUDENT CODE field in the list of Students.

I want is to create a flow that updates the 4000 records in the STUDENT column with the value of the STUDENT CODE column.

I've googled but I can't find any identical example

All responses (3)

Answers (0)

skindu 121 on at

Like (0)

Report

Re: Update lookup column with value another column

hi @SudeepGhatakNZ
It's possible to show more details of image 2, the item(...) expression, I am not understanding very well the 2 GetItems actions. Can you provide a more detailed example?

I have until here
Venoo 71 on at

Like (0)

Report

Re: Update lookup column with value another column

In order to populate lookup column properly, you need to use a ID of a corresponding record.

You will have to find a corresponding record for each row using get items, and then update item that will populate a lookup column. Just like shown above.
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Update lookup column with value another column

@skindu ,

Try this