import multiple email addresses from a single excel field into a single field in Sharepoint list

[FlorenceD]

Hi,

I need to export data from an excel file into a sharepoint list.

Everything is ok , except for multiple email addresses recorded in a single field in excel.

email addresses list is recorded as follow in excel 

The field in Sharepoint is in a list, allows multiple persons or group.

Thanks

[Mira_Ghaly · Accepted solution]

@FlorenceD 

Please follow the below sample, Say the first compose operation below is the input from your excel sheet

1. You need to split by ; by using the below expression

split(outputs('Compose'),';')

2. Initialize an array to hold your Multiperson data

3. Loop on the outputs from compose 2 in apply to each and compose the claims record as below in JSON and then append to the array variable as below:

4. Then you can pass the array variable to the create item as below:

[FlorenceDu]

Hi @Mira_Ghaly 

Thanks for your answer. It is perfect

[Mira_Ghaly · Accepted solution]

@FlorenceDu 

If this helped you solve your problem can you please mark it as accepted solution Thanks