Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to separate out 2 email ID's in CC from Lookup list column

Posted on by 43

Hello,

 

I have created one list with name "Admin"  which have 3 columns such as :

1. Name

2. Email

3. Location

 

Second list "User Details", which is referring to "Admin" list in one field called as "Admin Details" . Lookup column details as follows:

List Name : Admin

In this column : Name

Add a column to show each of these additional fields: Email

 

In some of record of "Admin" list there are 2 email ID's has been added in single record/item.

like for example one record as below:

1. Name : abc

2. Email : a@gmail.com; b@gmail.com

3. Location : Norway

 

Now I am creating some record in "USer DEtails" list and running flow on this list.

So I am triggering email through flow to all users like:

1. Who have created record in "User Details" list

2. To whom user has selected as Admin ( so there can be single/multiple person)

 

I got stuck at this multiple emails from Admin ( Lookup ) list

  • takolota1 Profile Picture
    takolota1 4,754 on at
    How to separate out 2 email ID's in CC from Lookup list column
    There is a way to split a column on delimiters to multiple records using only 6 actions & it will work for any number of records.
    https://community.powerplatform.com/galleries/gallery-posts/?postid=b4b53bc0-0e9a-ef11-8a69-6045bdee0f9b

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

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard