Group common questions across forms in Microsoft Forms

There is a frustrating missing feature in Microsoft Forms (and a lot of its competitors) in that you can only analyze your responses on a form-by-form basis, and not easily group common types of questions across multiple forms. In this video we explore how to address this using the Microsoft Forms API.

This video was inspired by a video by @Enea (https://www.youtube.com/watch?v=jjw52Jafl2o) which introduced the Microsoft Forms API and opened the possibility of using it to address this business need. At present this is only a working concept and relies upon undocumented features, but offers a little Power Apps and Power Automate fun on how there are often ways to bridge gaps that cause business process limitations.