Was able to get some of these answers via docs and this video
Storage
- Teams Approvals App Availability : Approvals created from a TEMPLATE are stored in CDS (Common Data Service). Responses are stored in Microsoft Forms.
- To see the actual tables and data, you need to go login to 1) Power Automate --> 2) Solutions --> 3) Microsoft Flow Approvals Core Solution OR 1) Power Automate --> 2) Solutions --> 3) Default Solution --> 4)Tables --> 5)Approval/Approval Requests/Approvals. Both paths seem to lead to the same tables.
- When viewing the tables, change the view to include "All Columns"!
Lastly, the key here is to note that there are two broad options here:
- Create Approvals and an Approval Template directly within Teams. You are limited here; you can't see any extra details columns when viewing your approvals, you can't add more than 2 response to a template.
- Create Customizable Approvals by Creating a List/SharePoint List and utilizing an approval template within Power Automate. In this case, the 'template' doesn't exist as an approval. Rather, the fields for your business process exist in a SharePoint List/Microsoft List. This is compared to custom fields in an approval being stored as a Microsoft Form (if you do everything from Teams).
This is covered at a very high level here: Customize Approvals