How to get the value from excel based on key value pair and send it in mail

[Kunal_Jain]

Hi,
I have an excel sheet that contains some questions along with the answers in “Yes or No”.
We need to send all the questions along with the answers who have “No” in the answer attached in mail.
Below attached is the image showing how it must look into mail.

Also attached is the excel sheet containing the question and answers
Questions book.xlsx (8.9 KB)
How should we complete this?
Thanks in advance!!

[mkankatala (Mahesh Kankatala)]

Hi @Kunal_Jain

→ Use the Read range workbook activity to read the Excel and store in a datatable called DT.
→ Then use the assign activity to store the Questions which has No option change it to a String format and store in a String datatype variable called MailBody,

- Assign -> MailBody = String.Join(Environment.NewLine, dtInput.AsEnumerable.Where(Function(row) row(1).ToString.Equals("No")).Select(Function(X) X(0).ToString+" "+X(1).ToString).tolist())

check the below workflow for better understanding,

Hope it helps!!