Answered

Sending email to unique list of Managers with the list of their users

(0) Share

Report

Posted on by Kashif_ptcl

Hi,

I'm fetching data from excel where I have to pick the unique manager names and their email addresses and send an email to all the Managers with the list of the users reporting to them who have not completed the online training. The Manager should receive one email with the complete list of users and I have to dynamically set/pickup the Manager name in the email body.

The dataset looks like below:

Name	Manager	Email	Video
User 1	Mark	dummy@example.com	Module 2
User 2	Riley	abc@hotmail.com	Module 2
User 3	Tony	xyz@gmail.com	Module 2
User 7	Riley	abc@hotmail.com	Module 2
User 4	Tom	jjj@abc.com	Module 2
User 5	Mark	dummy@example.com	Module 2
User 6	Mark	dummy@example.com	Module 2

With reference to the above dataset, Mark should receive one email with the list of three users (User 1, User 5, User 6)

The body of the email

Hi [Manager],

The following people have failed to attend the [Video] training:

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Sort by

Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

You can use the following article as starting point https://powerusers.microsoft.com/t5/General-Power-Automate/Read-rows-Excel-and-send-mail/td-p/45195

and this

https://powerusers.microsoft.com/t5/Building-Flows/Consolidated-email-based-on-date-in-excel/m-p/471936/highlight/false#M57275

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

Was this reply helpful? Yes No
Kashif_ptcl 26 on at

Like (0)

Report
Copy link

Link copied!

Hi Rahber,

Thanks for your reply. I already know and have read both the articles, in fact, I have built the flow which is working perfectly fine, it's reading the data from excel, filtering the records from excel based on criteria and I'm also able to filter the unique values from a particular field and successfully sending the emails. The only challenge I'm facing is not able to get the Manager's name(one of the fields in excel) dynamically in the email body.

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kashif_ptcl
Can you please post screenshots of your flow to see what you have done so far?
Thanks.

Was this reply helpful? Yes No
Kashif_ptcl 26 on at

Like (0)

Report
Copy link

Link copied!

Please see attached the screen shots, the workflow is running fine except from pulling the Manager Name dynamically in the email
body.

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kashif_ptcl
I have attached a file with a flow I created around your requirements. There are a few things you need to change, such as column names to match the columns in your Excel file. I tried to create an Excel file with the same columns you have, but the Excel screenshot didn't seem to show all the columns your file has. Please import it in your tenant, make the necessary changes to match your side and test it. Once done, please let me know if it worked.
Regards,

SendEmailtoManage...

Was this reply helpful? Yes No
Kashif_ptcl 26 on at

Like (0)

Report
Copy link

Link copied!

Thanks .

Yes I will definitely have a look and implement it by changing the column names.

Was this reply helpful? Yes No
Kashif_ptcl 26 on at

Like (0)

Report
Copy link

Link copied!

Hi

I have been trying to import the flow package under the solutions import but I'm getting the below error.

Was this reply helpful? Yes No
Kashif_ptcl 26 on at

Like (0)

Report
Copy link

Link copied!

Hi

Moreover, I have also tried importing the package file under the My flows Import. The package gets uploaded but the Import button is not enabled. See below.

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kashif_ptcl
You have to click the Action button for each of the 3 resources listed and set up the respective connection for each one.

Was this reply helpful? Yes No
Kashif_ptcl 26 on at

Like (0)

Report
Copy link

Link copied!

Thanks Fausto.

I'm getting the below error while imprinting.

Was this reply helpful? Yes No