Send email from JSON Information

(0) Share

Report

Posted on by bsmith736464

I'm currently building a new flow and trying to figure out the best method. I have a json that contains the following information:

{"LoginName":"name@email.com",
"CourseCode":"Course1",
"LessonTitle":"Course Title1",
"Status":"Completed",},

{"LoginName":"name@email.com",
"CourseCode":"Course1",
"LessonTitle":"Course Title2",
"Status":"Completed",},


{"LoginName":"name2@email.com",
"CourseCode":"Course2",
"LessonTitle":"Course Title1",
"Status":"Completed",},

{"LoginName":"name2@email.com",
"CourseCode":"Course2",
"LessonTitle":"Course Title2",
"Status":"Completed",},

What I am trying to achieve is for automate to go through this whole list of users, look up their manager and then send an email to their manager informing them of all their users and their accompanying status. I'm having difficulty because more than one user can have the same manager and then adding a long list of users to an email. Any help would be great appreciated.

Categories:

Building flows

All responses (1)

Answers (1)

Verified answer

MJain 2,450 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bsmith736464 ,

If you are thinking of grouping the data for each user by manager and then sending it here is a useful link for you to group the data and send the list of employees for the manager :
http://johnliu.net/blog/2018/6/do-group-by-in-flow-with-two-simple-elegant-loops

Thanks