This is not the most effective, but it would work. (Those of you who are more experienced will be able to provide a better answer than I.)
Say I'm taking a poll from 200 employees. I can ask employees to submit a Microsoft form I give them, and when they do, those triggers excel to add a new row of data. At the same time, I can have the submission of that data (the exact trigger for adding a row in excel) trigger sending me an email.
Depending on the program's objective, you can also set this up, so you get notified on your mobile device.
Microsoft has a similar template, with the extra step of sending a message in teams. The template is titled: Track Microsoft Forms response in Excel and notify through Teams and email
The following article may help point you in the right direction: https://powerusers.microsoft.com/t5/Building-Flows/Power-Automate-sending-e-mail-for-every-row-in-Excel-File-when/td-p/894560
Thanks to the following for pointing me in the right direction with this:
@Simmo86
@edgonzales
