From anonymous form to a secured SharePoint list in less than 20 minutes

Many of us have been in this situation where want to save data in SP List. Many times, our requirement is to have an anonymous user fill in the data and you want to end up using that data in a SharePoint list. Earlier this was not an easy thing to achieve with either SharePoint online or with SharePoint on premises because of various configurations and setup process involved to enable anonymous access. We can achieve the same thing today and deliver an end-to-end solution in less than 20 minutes. Technology Stack used for this scenario:

  1. TypeForm (https://www.typeform.com) for creating anonymous forms
  2. SharePoint online (Office 365 Tenant) for storing the final data
  3. Microsoft Flow to create the connection and pass data between TypeForm and SharePoint online

Pre-Requisites for this setup:

  1. You need to have a TypeForm account (free tier subscription works just fine, for more details on pricing check out https://www.typeform.com/pricing)
  2. You also need a SharePoint online site with edit access (read and write and create list) to store the data in a SharePoint list
  3. You need to sign up for Microsoft Flow with your Org account (The account you use to login to your SharePoint online site)

To capture a real-life scenario, we will demonstrate a registration form for an event that a user needs to fill out. This data will eventually be stored in the SharePoint list for further consumption by the marketing department. Let’s get started with our simple steps:

Creating the form in Typeform

We are going to create a simple form using the following columns:

  • Name*
  • Email*
  • Phone
  • Job Title
  • Company*
  • Country
  • City
  • Terms and Conditions Agreement*

Have a look at the video below to quickly get your registration form created:

Creating the form in SP and creating the MS Flow

Now that we have this setup done let us see what we need on the SP side and MS Flow side. We will create a SP List called “Registration” and add the same columns as we did in the form. We will do this with a user who has Edit access to the site. We will then login to MS Flow and create the final piece of connector to make this all work.

Feel free to reach out to me if you have questions regarding MS Flow, SharePoint or Office 365 in general.


Originally published at Jasjit Chopra’s Blog.