Over the last few months, I've been working with our IT group to automate the new hire process (by which IT sets up a new person with hardware and software). The old process kicked off with (GASP!) an Excel spreadsheet sent to hiring managers. As you might imagine, that Excel form and process was slow and fraught with error. So, it's getting a makeover using SharePoint, Power Automate, and Alteryx. This post will explain how I update SharePoint drop down lists using Alteryx tools. Read on to learn more.
Okay, the first link in this chain is setup and configuration. You might need to download the SharePoint tools if they are not already part of your environment. You can find them here. This page also has some great information.
Make sure to review the Alteryx Documentation on these tools because there are different versions, and the functionality is not the same from version to version. I am using the most updated version.
Now that basic setup is out of the way, let's talk about what I'm trying to do here. Ultimately, we are replacing an Excel spreadsheet (being used as a form) with a SharePoint list (being used as a form). The old spreadsheet included information such as the Hiring Manager's name and a "Mirror". The mirror is someone who is currently employed with the company. IT configures the new hire's access and AD group setup based on the mirror. Basically, Jane already works here. Mary starts next week. Make Mary's access just like Jane's.
So, our SharePoint form, has a drop down input for Hiring Manager and a drop down input for the Mirror. The drop down is populated by the contents of a SharePoint list that we update with Alteryx and PowerAutomate. This is an improvement over free form text. Here's what this part of the form looks like with the drop down.
Now, let me show you how we use Alteryx tools to make this happen.
First, when properly installed, you can find the SharePoint tools in the Connectors pallete. I had to hunt for them.
And just so it's crystal clear, I want to point out that I am using Alteryx tools to add to the SharePoint list and what is not shown is a separate PowerAutomate flow that removes from the SharePoint list.
Below, you can see how I configured the SharePoint List Input and Output tools. The tools specify the list and view to pull in/modify.
The SharePoint List Output tool also specifies the output method. I have chosen Append Existing. Keep scrolling to see all the available options.
The workflow runs on a nightly schedule and the drop down values are fresh.
Of course, this build was not without a few hiccups and trial and error. You'll want to watch out for these 3 gremlins.
Now you know how to update SharePoint drop down lists using Alteryx tools.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.