Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No