cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IPGeorgiev
Helper I
Helper I

Getting Data from Excel Online table and sending per E-Mail

Hi All,

 

I need help with achieving the following flow which for the time being I am unable to completed.

 

I have an excel table with the following data:

 

IPGeorgiev_0-1603915208884.png

 

So when the flow is triggered it should do as follows:

 

1. For each unique "NAME" entry to send an E-Mail to the respective employee (based on the name we will get the E-Mail using get profile) and the E-Mail should contain a small table displaying all training the employee is currently enrolled to (meaning they are present in the excel file) and what the status of the training is.

 

So for example Ben should receive the following E-Mail:

 

IPGeorgiev_1-1603915351977.png

 

Any ideas ?

 

Many thanks in advance!

Best regards,
Ivan

1 REPLY 1
sumurthy
Microsoft
Microsoft

I think you can achieve this using similar logic as described in this answer. 

You'd need Office Script to generate a simple array/object containing the summarized set of data as JSON and use that in the send email action. 

https://powerusers.microsoft.com/t5/Building-Flows/Mail-merge-excluding-duplicate-emails/m-p/731763#...

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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (3,769)