Answered

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

(0) Share

Report

Posted on by Community Power Pla...

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.

All responses (3)

Answers (1)

Community Power Pla... on at

Like (0)

Report

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

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.

shown
Community Power Pla... on at

Like (0)

Report

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

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

v-yuazh-msft on at

Like (0)

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

Hi @Anonymous,

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

You could refer to screenshot below to create the flow:

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:

The email would be sent as below:

Best regards,

Alice