cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Send an email by extracting all the Names of persons matched with todays date

I have a list with name "Training Nominations". It has columns like Emp ID of type Single line of text, Requester Name of type Person, Email Id of type Single line of text, Training Name of type Single line of text, Nomination End of type date and time. Nomination End column gives details of End of date of Training for which they have nominated. I need to match today's date with Nomination End date and Extract all the persons details like Emp ID, Requester Name and Email Id and send those details as one list through mail.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

I have made a test on my side and have created a sharepoint list as below:

Capture.PNG

You could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

 

The expression of  Emp ID in the Create HTML table as below:

item()?['Emp_x0020_ID']

 

The expression of Requester Name in the Create HTML table as below:

item()?['Requester_x0020_Name']?['DisplayName']

 

The expression of Email Id in the Create HTML table as below:

item()?['Email_x0020_Id']

 

The flow would run successfully as below:

Capture.PNG

 

The email would be sent as below:

Capture.PNG

 

Best regards,

Alice

 

 

View solution in original post

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

I have made a test on my side and have created a sharepoint list as below:

Capture.PNG

You could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

 

The expression of  Emp ID in the Create HTML table as below:

item()?['Emp_x0020_ID']

 

The expression of Requester Name in the Create HTML table as below:

item()?['Requester_x0020_Name']?['DisplayName']

 

The expression of Email Id in the Create HTML table as below:

item()?['Email_x0020_Id']

 

The flow would run successfully as below:

Capture.PNG

 

The email would be sent as below:

Capture.PNG

 

Best regards,

Alice

 

 

Anonymous
Not applicable

Thank you Alice for the best solution. It worked for me.

Anonymous
Not applicable

The solution provided is working good and extracting all the necessary columns but when there is no match with today's date (i.e., when the condition is not satisfied) also it is triggering empty mail with the custom headers as shown in below image. Please help me with the issue.

 

 

shownMail.PNG

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,104)