Forum Discussion
Analyzing the responses of a Microsoft From right after submitting without email
Philippe_Pecqueur what we always do is to use a flow in Power Automate to save the responses into a SharePoint list. Not only does this help with auditing the responses but it allows for doing color-coding or other formatting based on a response, you can connect Power BI to it for further analysis and so on. It works very well.
A simple example is in the image below, and you can add follow-on actions like send an email for example:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliottThank you for your reply, and I could see this good hint in some places.
But as I mentioned, I wish to analyse the responses RIGHT AFTER submiting the form, the goal is to gather the data, but do not request and email, and display the analysis for the user anyway ( his own analysis, not the global ones, with just simple rules )
It seems not possible with Forms...
