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

  • Preparing for Windows 10 end of life: key dates and how ramsac can help 

    Preparing for Windows 10 end of life: key dates and how ramsac can help 

    Microsoft 365

    A significant change is on the horizon with Windows 10 approaching its end of life next year. Preparing for this change is vital for maintaining security and efficiency of [...]

    Read article

  • Changes to Microsoft 365 Licensing for Nonprofit Organisations

    Changes to Microsoft 365 Licensing for Nonprofit Organisations

    Microsoft 365

    Microsoft has recently made adjustments to its licensing options for nonprofit clients, in this blog we break down the key points and implications to the licensing changes [...]

    Read article

  • Navigating the new Microsoft 365 Teams licensing: What you need to know

    Navigating the new Microsoft 365 Teams licensing: What you need to know

    Microsoft 365

    Microsoft has recently announced updates to its licensing structure for Microsoft 365, particularly regarding the inclusion of Teams in this blog, we explain what that means for you [...]

    Read article

  • Which to use: Microsoft Planner or Microsoft Project? 

    Which to use: Microsoft Planner or Microsoft Project? 

    Microsoft 365

    Microsoft Planner and Microsoft Project are dynamic software tools offering enhanced features that support effective project management. But when it comes to Microsoft Planner vs Project what is the [...]

    Read article

  • Say hello to the new Microsoft Teams

    Say hello to the new Microsoft Teams

    Microsoft 365

    Microsoft is retiring the classic version of Teams at the end of March 2024 and moving everyone to the new Teams [...]

    Read article

  • Does Microsoft 365 provide backup protection for organisations?

    Does Microsoft 365 provide backup protection for organisations?

    Microsoft 365

    Many organisations that use Microsoft 365 are unaware of the importance of a separate Cloud backup solution, this blog explores why these are so important. [...]

    Read article