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?