You’re offline. This is a read only version of the page.
339
Hello there,
I have a sharepoint list called "Direção Comercial", and, in each "Direção Comercial" I have one Department associated. Im trying to get those Departments and send an email with their associated "Direção Comercial". The "Direção Comercial" can have Departments duplicated with each "Direção Comercial".
The problem is, I wanna send an email per each Department, but I don't know how to get the unique Departments without duplicating them.
This gets more difficult than ever, because i also don't know how many "Direção Comercial" or departments there is (because it changes every 2 weeks).
Each department has a unique code.
Can someone help me?
Hello @yashag2255 ,
We want to send the email to each Department with the information of their Direçao Comercial associated. The field Department is a String. No, the email I will get to another list. The only problem is to send the email to each Department with a table of their Direçao Comercial.
I am doing a for each on the list of Direção Comercial. then I save the information I want on a variable. After I am doing a compose to show this information on a html table. Finally I am sending an email with the result of compose. But in this way it will send me an email with all the Direcao Comercial. And I want an email for each Department with their Direçao Comercial associated.
Hi @Field
Can you share some more details on this? What trigger are you using/ want to use? Also, what is the datatype of the "Department" column? Whom do you want to send the email? Does the Department column contain the email address too?
Share
Report
All responses (
Answers (
