Microsoft 365 case study: Forms, Flow, SharePoint & PowerBI

What is office 365 a short guide
The need

There was a requirement to capture information from visitors to our stand at an event, have that data available quickly to our Managing Director who was speaking, display it on a screen on the stand, and then make it available for our Business Development team to follow-up after the event.

We considered having something created for us, but it would have been expensive and involved long lead times.

We also looked at several off-the-shelf cloud-based services designed to survey event attendees, but they were either intended for live audience participation, or for surveying with analysis after the event, so none were really suitable.

The solution

So, we decided to build our own solution using pulling together elements of the Microsoft 365 platform – Forms, Flow, SharePoint and PowerBI.

Microsoft 365 – Forms

Microsoft Forms was used to quickly create a form to capture answers to questions, which was run on a Windows 10 tablet. As the survey form was browser based, no data was stored on the tablet.

We also asked for GDPR contact consent and depending on their answer, then prompted for an e-mail address. With the correct permissions survey results are summarised live within Forms, so our Managing Director could refer to live information in his talk.

Microsoft 365 – Flow

Microsoft Flow was used to automatically push the responses into a SharePoint Online list. Flow can be used to easily automate many processes within Microsoft 365. For example, we use it within ramsac for automating onboarding a new client, it creates standard files and folders within SharePoint Online, and sends various e-mails to the appropriate teams.

Microsoft 365 – PowerBI

Microsoft PowerBI was then used to display the survey results on a large screen. Creating attractive reports is quick and straightforward in PowerBI, and as it’s cloud based it just requires a browser, no back-end servers or locally installed reporting software.

Microsoft 365 – SharePoint

Finally, after the event the information in the SharePoint Online list could easily be imported into our CRM system. Nothing was stored on the tablet used for the survey, or the laptop used to display the data. It was easy to just delete the contact information in Forms and SharePoint Online for GDPR compliance, and there was no risk of data being compromised if any of the hardware were lost or stolen at the event.

Related Posts

  • Understanding Data Exposure Risk in SharePoint and OneDrive

    Understanding Data Exposure Risk in SharePoint and OneDrive

    CybersecurityMicrosoft 365Technical Blog

    As the way we work continues to evolve, proactively managing data exposure in SharePoint and OneDrive is essential to safeguard sensitive information and maintain trust in an AI-driven world. [...]

    Read article

  • Exchange Server 2016 & 2019 end of life: what you need to know 

    Exchange Server 2016 & 2019 end of life: what you need to know 

    Microsoft 365

    Exchange Server 2016 and 2019 will reach end of life on October 14, 2025. Find out what this means for your organisation, the risks of staying on an unsupported [...]

    Read article

  • How to know if a Microsoft security alert is real

    How to know if a Microsoft security alert is real

    CybersecurityMicrosoft 365

    Microsoft security alert emails help you to know if someone is potentially trying to illegally access your Microsoft account. However, scammers and cybercriminals are well aware of this and [...]

    Read article

  • Python In Excel Brings Increased Computing Power

    Python In Excel Brings Increased Computing Power

    AIMicrosoft 365

    Microsoft Excel's integration with Python brings advanced data analysis and visualisation capabilities to spreadsheet users. While this powerful combination offers enhanced features for enterprise users, the cloud-based implementation comes [...]

    Read article

  • What is cloud.microsoft?

    What is cloud.microsoft?

    Microsoft 365

    Microsoft is consolidating its various domains to cloud.microsoft, marking a significant shift in how users access Microsoft 365 services. This move, rolling out through 2025, promises improved security, faster [...]

    Read article

  • Copilot vs ChatGPT: Which is Right For You?

    Copilot vs ChatGPT: Which is Right For You?

    AIMicrosoft 365

    When you’re looking for an AI chatbot to use, most people may immediately jump to ChatGPT. However, Microsoft’s Copilot is a fierce competitor to ChatGPT and has a wide [...]

    Read article

Quiz yourself

Are you more cyber savvy than an 11 year old?

11-14 year olds get asked these questions in school. Could you get these right?