160
Hi all,
I have an Excel with several tasks per colleague. I would like to create a flow that sends a unique email with all tasks below 100% to the colleague with these tasks.
in the email body I would like to put the excel cells with his tasks
Thank you very much
Hi @manuelstgomes ,
I like the solution, could you explain the thought process why the condition used is People contains Email then if falls Append Array is Name: People and Value: Email.
Sorry I am not a programmer but would like to understand the design.
Cheers,
kbw
Hi @Kamacete
I forgot to tell you how to add a second condition. You need to go into "Advanced Mode" in the filter and then use the formula:
Share
Report
All responses (
Answers (
@and(equals(item()?['Email'], outputs('Compose')),equals(item()?['Avg'], '1'))
This will check 2 things:
1. If the email is the one we're parsing in this step of the loop.
2. If the Avg contains 1
You'll get something like this:
The end result works like this:
Can you please check if and let me know if you have any questions?
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
HI @Kamacete
In the "Filter Array," add a new line with the column name and 100. With this, you'll get a filter by people and by the completed task.
Can you please check if and let me know if you have any questions?
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Hi @Kamacete
Sure. There are a few steps, but I'll guide you through them. Also, I've attached a template that you can adjust to your needs.
First, we get all rows and add to an array variable the unique emails. These are the emails we want to send.
After that, we do an "Apply to each," filter the values from excel by email, generate a nice table to send to them, and then send the email.
Can you please check if and let me know if you have any questions?
Cheers
Manuel
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
