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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / import multiple email ...
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
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 

emails.png

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

 

Thanks

I have the same question (0)
  • Verified answer
    Mira Ghaly Profile Picture
    Mira Ghaly 11,409 Moderator on at
    Re: import multiple email addresses from a single excel field into a single field in Sharepoint list

    @FlorenceD 

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

    Mira_Ghaly_0-1643620440799.png

     

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

    Mira_Ghaly_1-1643620502035.png

     

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

    2. Initialize an array to hold your Multiperson data

    Mira_Ghaly_2-1643620579991.png

    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:

    Mira_Ghaly_3-1643620664833.png

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

    Mira_Ghaly_4-1643620775295.png

     

     

  • FlorenceDu Profile Picture
    FlorenceDu 3 on at
    Re: import multiple email addresses from a single excel field into a single field in Sharepoint list

    Hi @Mira_Ghaly 

    Thanks for your answer. It is perfect

  • Verified answer
    Mira Ghaly Profile Picture
    Mira Ghaly 11,409 Moderator on at
    Re: import multiple email addresses from a single excel field into a single field in Sharepoint list

    @FlorenceDu 

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

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 797 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
developerAJ Profile Picture

developerAJ 319

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans