Trying to get seperated values

(0) Share

Report

Posted on by Field

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?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Re: Trying to get seperated values

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?

Was this reply helpful? Yes No
Animoroly 45 on at

Like (0)

Report

Re: Trying to get seperated values

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.

Was this reply helpful? Yes No