web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate import multiple email ...

Power Automate

Unanswered

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

(0) Share

Report

Report

Posted on by FlorenceD

8

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

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report
@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:

Was this reply helpful? Yes No
FlorenceDu 3 on at

Like (0)

Report

Hi @Mira_Ghaly
Thanks for your answer. It is perfect

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@FlorenceDu

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

Was this reply helpful? Yes No

Join the conversation