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

Answered

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:

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

Mira Ghaly 11,415 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@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 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly
Thanks for your answer. It is perfect
Verified answer

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@FlorenceDu

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

Join the conversation