Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Add an analysis tab using Pivot Tables to an Excel sheet automatically populated by Forms data

Brass Contributor

If Forms responses generate an Excel sheet to hold the data, can I create additional tabs on that sheet to run predefined reports based on Pivot Tables?

 

If I want to use PowerBI against an excel sheet generated by a user created form, where is the excel sheet located so I can link it to PowerBI?

 

Thank you

0 Replies