Search
StarWind is a hyperconverged (HCI) vendor with focus on Enterprise ROBO, SMB & Edge

[Azure] Call an Azure Function webhook from an automated Flow and a SharePoint list

  • January 15, 2019
  • 4 min read
Cloud and Virtualization Architect. Florent is specializing in public, hybrid, and private cloud technologies. He is a Microsoft MVP in Cloud and Datacenter Management and an MCSE in Private Cloud.
Cloud and Virtualization Architect. Florent is specializing in public, hybrid, and private cloud technologies. He is a Microsoft MVP in Cloud and Datacenter Management and an MCSE in Private Cloud.


SharePoint Logo

Now that we’ve an Azure Function that works correctly, we will connect to a SharePoint Online site, and, in Site contents, create a list, to manage automation of our process :

SharePoint Online site - New List

Give a name and a description to this list. You can choose to show it in the lateral panel or not :

SharePoint Online site - Create List

Modify the Title column, with the new name LastName and add a new column, with type Single line of text :

SharePoint Online site - Create New User - Add column

Give it a name, Firstname and don’t forget to say that this column must contains information before being published :

SharePoint Online site - Create a column

Now that we’ve our 2 columns, we’ll use Flow to automate the call to our webhook. Click on Flow > Create a flow :

SharePoint Online site - Cloud Journey

Choose the flow Start approval when a new item is added :

SharePoint Online site - Create a flow

A new window will appear, on the Flow dedicated website. Click on Continue :

SharePoint Online site - Start Approval

Here, we will remove the approbation. Remove all items, except the first one, and add a new item, with type HTTP. Configure the method to POST, give the URI that you get from your Azure Function, and in the body, add the JSON that we used during tests, by replacing values by SharePoint items Firstname and Lastname :

SharePoint Online site - When a new item is created

Save it, go back to your SharePoint list and click on New. Provide a first name and a last name to create a new user :

SharePoint Online site - CloudJorney - Save

The user has been added to the list, it will normally start the Flow :

SharePoint Online site - CloudJorney - Create New User

After few seconds, the Flow job is finished. You can click on it to have more details :

SharePoint Online site - CloudJorney - Create New User - Succeeded

SharePoint Online site - CloudJorney - Create New User - Flow ran successfully

And my user has been created correctly :

SharePoint Online site - CloudJorney - Profile

In the last part, we will see how to create a « User Friendly » application for our HR team, for example, that will do the on boarding of new employees 😊

 

Found Florent’s article helpful? Looking for a reliable, high-performance, and cost-effective shared storage solution for your production cluster?
Dmytro Malynka
Dmytro Malynka StarWind Virtual SAN Product Manager
We’ve got you covered! StarWind Virtual SAN (VSAN) is specifically designed to provide highly-available shared storage for Hyper-V, vSphere, and KVM clusters. With StarWind VSAN, simplicity is key: utilize the local disks of your hypervisor hosts and create shared HA storage for your VMs. Interested in learning more? Book a short StarWind VSAN demo now and see it in action!