cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlprentice
Resolver II
Resolver II

How do I handle 1 to many situations when emailing using Excel?

I basically have an Excel file with hostnames, and email addresses of users.

 

I'd like to send a user 1 email with all of their hostnames.

 

Any help with this is appreciated on how to accomplish this.

 

@eka24 any ideas? 

 

1 ACCEPTED SOLUTION

Accepted Solutions

I followed the instructions from this link, and am in good shape:

Solved: Mail merge excluding duplicate emails - Power Platform Community (microsoft.com)

 

I'll make sure to mark your answer as the solution if it also meets the end goal I was after. Here are some example images of my currently complete flow.

11.PNG

22.PNG

View solution in original post

4 REPLIES 4
BamDastard
New Member

I would set a table range on the spreadsheet, then you can use the Get a Row step in your flow with the email address as the key, and pull all the hostnames with that key into a value you insert into the email.

 

Let me know if you need additional help with it and I can try to model it for you.

This sounds like the solution, could you please model an example?

I followed the instructions from this link, and am in good shape:

Solved: Mail merge excluding duplicate emails - Power Platform Community (microsoft.com)

 

I'll make sure to mark your answer as the solution if it also meets the end goal I was after. Here are some example images of my currently complete flow.

11.PNG

22.PNG

View solution in original post

BamDastard
New Member

Awesome! That's way more detailed than what I was going to hobble together! Glad to see you got it going!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (22,843)