Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

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

Posted on by 2
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.
  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,107 on at
    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.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,532

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,050

Leaderboard