cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Super User III
Super User III

Hi @TG2019 

 

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 blog

Power Automate Video Tutorials
Highlighted
Community Support
Community Support

Hi @TG2019 ,

 

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.

Highlighted

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!

Highlighted
Super User III
Super User III

Hi @TG2019 

 

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 blog

Power Automate Video Tutorials
Highlighted

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

Highlighted
Super User III
Super User III

Hi @TG2019 

 

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 blog

Power Automate Video Tutorials
Highlighted

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.

Highlighted

Still having trouble figuring this out. Any ideas?

Thanks!! 🙂
Highlighted

Hi @TG2019 ,

 

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (12,012)