web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dissatisfied Customer ...
Power Automate
Unanswered

Dissatisfied Customer Survey Result - How can I make an notification email to me???

(0) ShareShare
ReportReport
Posted on by
Hi. 
 
Recently I created Customer Satisfaction Survey through Microsoft Form.. 
The form automatically created an excel file, so I added manually score and result section. 
In result section, if the score is below 15, it indicates unsatisfied.
 
Now, I want power automate to let me know whenever there is a new unsatisfied result..
I created something as attached, but the thing is, the system sent me multiple emails after reading all dissatisfied results..
 
I tried to put the coding in the first condition, 
last(body('List_rows_present_in_a_table')?['value'])?['Result'
 
but it doesn't work..
Can you help me on this issue?
 
Thank you very much 
Categories:
I have the same question (0)
  • Suggested answer
    developerAJ Profile Picture
    4,741 on at

    Sorting by Completion Time in descending order and using Top Count = 1 will return the latest record, but this is not the correct approach.

     

    A better approach is to replace Excel with a SharePoint list. Use the When a form response is submitted trigger, calculate the score in Power Automate, and insert a new item with the score into the SharePoint list. Then, check whether the score exceeds the defined threshold and send an email accordingly.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 507 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 267 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard