Answered

To send Email with required data in HTML table to respective users

(0) Share

Report

Posted on by sagarbtech008

Hi All,

Very Good evening to all. Hope all are doing good. I need your help in one of the requirements. I have a table with some information with users Email. I need to send the mail and respective user can see their data in HTML table. for ex:-

User Name Employee Id Rank Work TimeUser Email Id

Jyothi	51915301	E2.2	3.63	madathala.nagar@hcl.com
Sagar Sahoo	51515486	E2.2	6.34	sagarhemaranjan.s@hcl.com
Pitchumani Varathara	51303704	E2.2	7.72	pitchumani.v@hcl.com
Chidanand Bangalore	40108804	E4	6.63	chidanand.kb@hcl.com
Venkata Prasad	51832483	E5	6.62	venkataprasad@hcl.com
Gopal A	40131208	E4	6.62	gopala@hcl.com

In the above example I need to send the communication to those users who are having Work Time column is less than 7 and Rank is less than E4 with their respective data. Like for the first user i need to send the Email with table having her information only. Not all other users information.

User Name Employee Id Rank Work TimeUser Email Id

Jyothi

51915301

E2.2

3.63

madathala.nagar@hcl.com

Any help in this will be highly appreciated.

I tried a bit but it is sending all the information available in the table . The result is coming like below.

Hi Sagar Sahoo,
Your Work Time recorded by Nippon is low as per Nippon Standard. Please improve it.

UserName	EmployeeID	WorkTime
Jyothi	51915301	3.63
Sagar Sahoo	51515486	6.34
Pitchumani Varathara	51303704	7.72
Chidanand Bangalore	40108804	6.63
Venkata Prasad	51832483	6.62
Gopal A	40131208	6.62

But expectation is only i can see my data not all others data to be displayed.

Here is what i have done into it. Please help how can i achieve this.

Further expanding the Style to initialize Variable and Sending mail.

Regards,

Sagar

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @sagarbtech008 ,

I think currently you are sending the complete HTML data to all users. You should use a filter array action to filter the data based on the mail id of the user and then send the email.

Please check the screenshots of the flow , that I have built.

Please ignore compose 4.

I am using the array created at the beginning to check if the current Rank exists in that or not. If it exists , then the condition would be false.
Below expressions are used in the first condition.

float(items('Apply_to_each')?['Hours'])
float('7.00')

To get the email in the filter array expression on the left below expression.

item()?['Email']

The body of filter array should be used as a input for the create html table action.

For rank you can split the string that you are reading from excel and compare the value if its less than 4 or not.
Hope this helps!

If this solves your problem , do give this answer a thumbs up please mark this as a solution.

Thanks,

Was this reply helpful? Yes No
sagarbtech008 43 on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG ,
Thanks a lot for your quick support. I am almost there. but the result is showing like this below. Repetition of same information is coming. If you look at the result, same value is repeated for 6 times. Please help in fixing this.
UserName
EmployeeID
WorkTime
Sagar Sahoo
51515486
6.34
Sagar Sahoo
51515486
6.34
Sagar Sahoo
51515486
6.34
Sagar Sahoo
51515486
6.34
Sagar Sahoo
51515486
6.34
Sagar Sahoo
51515486
6.34

Regards,
Sagar

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @sagarbtech008 ,

Can you share screenshots of your flow.

From filter array you should get only one row.

Was this reply helpful? Yes No
sagarbtech008 43 on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG ,
Please find the screenshot of Entire flow below.

Regards,
Sagar

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @sagarbtech008 ,

Got it ,
1. While creating an html table you should use the output that you receive from filter array action not the value array that you get from list rows present in a table.

2. Also can you check the length of your filter array using the length function and see how many records are returned. And you can cross check if you get the same number of rows in your data source for that mail id.

Hope this solves your issue. Please give this a thumbs up and mark this as a solution if this helps.

Thanks,
Sanmesh

This should

Was this reply helpful? Yes No
sagarbtech008 43 on at

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG ,
In Filter Array i think it is not giving correct result. Hence the outcome is not coming right. i am not sure where and what i am missing here to add. Please see the Flow Result while testing. I am pasting from Filter Array. Because the problem seems to start here. And Output is showing nothing .

The above are test result. And my flow after small correction what you suggested, but it is not coming correctly.

Please let me know if i am doing something wrong here. Help me to correct it. Thanks a lot for your continue support.

Regards,
Sagar

Was this reply helpful? Yes No
Verified answer

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @sagarbtech008 ,

Are you sure that you are passing the correct email ID while filtering?

For testing purpose remove the expression and hardcode a single email and see if the data is filtered correctly or not.

After that filter array returns records when you hard code the value , you can try to add the correct expression in the filter.

Was this reply helpful? Yes No