Users submit intranet requests it in Forms, it writes to my Excel file, then I can triage the request, manage that data in my Excel file, without having to download it, or writing a Flow to write the data to the Excel file. I’ve set up a Form as a request tool for the intranet. This also comes in handy when you want to use the form for more than just a survey tool. People just want to collect data, in a clean manner, and then analyze it in Excel. There have been numerous use cases for this over my last 20 years of consulting. However, if you have an existing Excel file, you can use Forms to import directly into your existing Excel file! We know this can be easily exported to Excel. We know about Microsoft Forms, the Office 365 quiz and polls tool. I came across this neat little feature and instantly fell in love. Create a Form and have the data save directly in Excel (this post).
This post is the first of a few where we look at how easy the Office 365 stack integrates.
