cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Possible to create a flow that sends an email if the average NPS score of all records in a Forms Pro survey drops below a certain number?

Hello,

 

I want to create a flow that sends an email each time the average NPS Score of all records in a Forms Pro Survey drops below 8 out of 10.  Is this possible?  If so, how?

 

Thanks!!

9 REPLIES 9
abm
Super User III
Super User III

Hi @Anonymous 

 

What is NPS Score? Is this something you are capturing as part of Form submission? 

 

If you looking to find the average score from all records then you need to get all the records from where ever you are storing the form submission responses using List records and workout the average. 

 

 Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

As @abm  asked, please share more details about the NPS Score in the survey so we could try to understand your requirement and provide a proper workaround for you.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

NPS stands for Net Promoter Score.  I have an NPS question in my Forms Pro survey, where a user has to choose a number between 1 and 10, with 10 being the highest score.

 

 

Thanks!

abm
Super User III
Super User III

Hi @Anonymous 

 

Thanks for your reply. The average your discussed is for single form entry or all records (Multiple submissions). Where you storing this responses now?

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Anonymous
Not applicable

Hi @abm, I am storing responses in the Forms Pro Survey Response entity in the Common Data Service.

abm
Super User III
Super User III

Hi @Anonymous 

 

The average your discussed is for all records (Multiple submissions) from the database?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Anonymous
Not applicable

All survey submissions from one particular survey called "Client Survey".  There is a that field in the entity called "Survey" that shows the name of the survey.

Anonymous
Not applicable

Still having trouble figuring this out. Any ideas?

Thanks!! 🙂

Hi @Anonymous ,

 

You should explain more details about the field and the items in the entity so we could better understand the issue and provide the workaround.

I suggest that you could take a try to create the flow and you could ask here if you have problems.

 

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,134)