You’re offline. This is a read only version of the page.
Hi everyone, I have a flow about sending birthday celebrating email but It contains complicated conditions. I run the query correctly up to a certain point, but I had trouble adding more than one person to the cc. In transform the data using the power query step, I'm extracting the emails to be added to the cc for each person but I can't combine cc's into one mail.
In compose 2 step , I'm getting name from the birthdate table and then, I'm checking birthdates for each name. If title is not manager, the second condition runs .
Here is similar outputs of query step. For example, I want to add abc@gmail.com and xyz@gmail.com to cc for 'def' and
add dfg@gmail.com and ddd@gmail.com to cc for req.
| man_email | name |
| abc@gmail.com | def |
| xyz@gmail.com | def |
| dfg@gmail.com | req |
| ddd@gmail.com | req |
If I'm checking for the def, I just want to add abc@gmail.com and xyz@gmail.com to cc.
Share
Report
All responses (
Answers (
410
