Putting multiple filters for a excel table and sending an automated email

(0) Share

Report

Posted on by CU25021107-0

I do have excel table with columns sr_no, complaint_id, cust_name, cust_email, complaint_status, feedback_status stored in my sharepoint. I need to send a feedback to the customers whose complaint has been resolved. So the filter conditions must complaint_status eq "CLOSED" and feedback_status ="FALSE", so for these records, we need to extract the customer email, complaint, customer name. I need to send the emails to these all these customers with below format:

"Dear [Customer Name],

Thank you for your patience while we resolved your complaint (Complaint ID: [complaint_id]).
We would appreciate it if you could take a moment to rate your experience with us by clicking [here].

Regards,
BMW"

Can anyone help me with building this flow. I tried using the "list the rows present in table", but we can use only one filter condition and not two.

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Putting multiple filters for a excel table and sending an automated email

After listing the rows, add a "Filter array" action to filter the data based on your conditions.

Was this reply helpful? Yes No