
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
This is the mirrored SharePoint list that we want to move this line to when the status changes to Closed/Filled.
My process was so far
This is the output and you an see that only the title is appearing bank but nothing in the lookup Updates column.
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'
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.