cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yerlasdutco
Helper III
Helper III

Send email to distinct email

Hi folks,

 

I have a excel c olumn with list of emails. Some of email can be repeated

How can I send mail only once, if email already sent to this email address ?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
momlo
Impactful Individual
Impactful Individual

Hi @Yerlasdutco 

It depends on your logic and goal.

One option is below, but it really depends on the context you are automating.

 

1. Use excel actions (or my favorite sql 😁) to retrieve email addresses to the list variable

2. Use list action to remove duplicates

2. Use for each loop to send emails

View solution in original post

2 REPLIES 2
momlo
Impactful Individual
Impactful Individual

Hi @Yerlasdutco 

It depends on your logic and goal.

One option is below, but it really depends on the context you are automating.

 

1. Use excel actions (or my favorite sql 😁) to retrieve email addresses to the list variable

2. Use list action to remove duplicates

2. Use for each loop to send emails

@momlo 

 

What will be in loop, if distinct emails saved in List?

Yerlasdutco_0-1669198599359.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,258)