Unanswered

Match employee ids to get email and send list of item assigned to them

(0) Share

Report

Posted on by Rachel19

I need my automate to send an email of a list of items to the owner, but the owner email is in a separate table. I’d also like to include the total count of actions items assigned to them.

I have a data verse table that has a list of records that includes the employee ids. In a separate data verse, I have the employee id and email.

Table 1

Employee #	Action item	Due date
123	Complete report	11/2/2023
456	Review report	11/10/2023
123	Start next report	11/5/2023
123	Project completion	11/20/2023

Table 2

Employee #	Employee email
123	User123@outlook.com
456	User456@outlook.com

result:

To: User123@outlook.com

You have 3 action items due. Please see below for more details:

Action item	Due date
Complete report	11/2/2023
Start next report	11/5/2023
Project completion	11/20/2023

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @Rachel19 ,

According to your description, you want to Match employee ids to get email and send list of item assigned to them in your two Dataverse Tables.

I test it in my side and this is my test data which is the same yours:

And this is the flow you can refer to, You may need to modify the parameters according to the actual column names of your Dataverse :

(1)The List rows step:

(2)The "Apply to each" step:

Best Regards,

Wearsky

Was this reply helpful? Yes No
Rachel19 11 on at

Like (0)

Report

@v-xiaochen-msft thank you for your response! However, your way just sends all actions to every single email listed in the employee table.

This is what I have and it almost works, but it seems like after the first run it starts sending action items to the wrong person -

Was this reply helpful? Yes No
Rachel19 11 on at

Like (0)

Report

@v-xiaochen-msft This is your version which is causing every outstanding item to be sent to every single email listed in the user table

Was this reply helpful? Yes No