web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy Row From Source S...
Power Automate
Unanswered

Copy Row From Source SharePoint List to another SharePoint list - Issue with handing Multi Choice Lookup Column form another - How to do it?

(0) ShareShare
ReportReport
Posted on by

I was asked to build a process to move the entire line from one SharePoint list to another SharePoint list when the recruitment status changes to Filled/Closed search.  I am getting stuck on lines where one of the columns which is a multi select Lookup column.  So basically this line contains a position and then the multi select column contains all the people who applied or are being recruited.  It is important to distinguish though that these are people but this is not a PERSON column. 

 

This is the source SharePoint List:  As you can see when you look at the Providers column this is the multi select lookup column.  You can see that right now the status is Open/Active

AnupamD_0-1682694153573.png

 

 

This is the mirrored SharePoint list that we want to move this line to when the status changes to Closed/Filled.

AnupamD_1-1682694153428.png

 

My process was so far 

AnupamD_2-1682694153655.png

 

AnupamD_3-1682694153658.png

 

 

This is  the output and you an see that only the title is appearing bank but nothing in the lookup Updates column.

AnupamD_4-1682694153751.png

 

This is the flow audit, I an see the providers in the Output of the Select but it is not entering the Create item action, value showing 'Null'

AnupamD_0-1682694779595.png

 

You can see that the Updates is blank.  

 

I know its probably because I am not handling the lookup value properly for this column type.  If someone who has dealt with this type of situation can comment please lend a  helping hand.  Just note that the Updates or the Providers column is not  a PERSON column. 

 

Thanks.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard