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.