Work with common questions across multiple forms using the Microsoft Forms API

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.

Chapters:
0:00 Introduction
0:37 Outlining the business problem
2:30 The Microsoft Forms API
4:12 Overview of the environment
6:50 Tour of the app
11:30 Database structure
13:00 The Canvas app
13:40 Getting forms data using the API
15:40 Creating question groups in Power Automate
17:25 Data export in Power Automate
32:35 To do items
34:50 Caution in using this undocumented Forms API
36:30 Conclusion

Apart from publicly accessible information all user data or other related information shared in this video is created for demonstration purposes only. User accounts, passwords, or other data used as part of any demonstrations shown in this video have been created specifically for that purpose and are not any individual or company's private information or data.

[avinoamrothenberg]

Great video. That is a very neat solution for a very common problem.
And what a massive work you have done there with the flows - kudos to you

[kaushiq]

Good Video.. How to add remark (I want some description from my team mates) down to any question??