Do you need an easier way to process employee equipment requests? By adding automation to your request and procurement processes, you can ensure that all your employees have access to the equipment they need to be productive in the workplace. This includes new starters, who may require a list of hardware and office equipment on their very… Read More
Do you need an easier way to process employee equipment requests?
By adding automation to your request and procurement processes, you can ensure that all your employees have access to the equipment they need to be productive in the workplace.
This includes new starters, who may require a list of hardware and office equipment on their very first day. With many employees still working from home, an automated equipment request platform can also help your remote staff work safely. Regardless of geographical location, these remote employees can easily request equipment such as lumbar support chairs and standing workstations, and have it shipped directly to their home address.
In this article, we’ll be using Microsoft Power Automate, Microsoft Forms, and Outlook to create an automated request and procurement system. With this workflow in place, requesting equipment becomes as simple as completing an online form. Your busy HR department can then approve or deny each request, simply by reading the automated email and clicking a button.
What we’ll be building
In this tutorial, we’ll be creating an “Equipment Request” form, using Microsoft Forms.
Your employees can use this form whenever they need to request a piece of equipment. For employees who are working from home, we’ll create a field where they can enter their home address. This allows you to ship equipment directly to the employee’s home, potentially saving you a considerable amount of time.
When the employee clicks “Send,” Microsoft Forms will display a “Your response was submitted” message. This ensures the employee knows you’ve logged their request successfully.
Whenever an employee submits a request, Power Automate will extract all the relevant information and send an email to the nominated individual or department. For example, you might send these emails to your HR department, or use Automate’s dynamic content to forward each request to the employee’s specific manager or supervisor.
This individual or team will receive the email, and can then either approve or deny the equipment request. The employee will automatically receive an email, informing them of the outcome.
These emails are fully customizable. For example, your denial email might include a Microsoft Form where the employee can re-submit their application with more information, or you might include a shipping number in your approval emails.
How to create an equipment request form, with Microsoft Forms
The first step is creating the equipment request form. You can customize this form to collect the information that matters to you, but to keep things simple we’ll be requesting the employee’s contact details, and some information about the equipment they require.
● Log into Microsoft Forms.
● Select “New Form.” This launches Microsoft’s form editor.
● Select “Add New.”
● Make sure the “Questions” tab is selected.
● You’ll typically want to add some fields for the employee’s contact information. For each field, click “Text,” and then enter the label that you want to display above this field. For example, I’m creating fields for the employee’s name, and email address. If the employee in question is working from home, you may want to request their home address. This allows you to ship the requested equipment directly to their home office. Unless you have a specific reason not to, you’ll typically want to enable the “Required” slider for all the fields in your form.
● If your employees can choose from a variety of equipment, you may also want to provide a list of equipment categories, for example Additional Monitor, Laptop, Home Office Chair, or Docking Station. This can also be useful for indicating the kind of equipment that your employees can request.
● Finally, you may want to create a text field where employees can add some information to their request. For example, they might include a link to the exact model of office chair they require, or provide an explanation about why they need a replacement docking station. To create this text box, select “Add New > Text.” You’ll typically want to enable the “Long answer” slider as this gives your employees more characters to work with.
This is the basic information you’ll typically require for any employee equipment request. However, you can add more fields or multiple choice questions, depending on the information you require.
You can test how your form will appear, by selecting “Preview.” You can also check how this form will appear across desktop and mobile devices, using the buttons along the top of the screen. Once you’re happy with the results, it’s time to take your form public.
Adding a Microsoft Form to your employee portal or website
You can add a Microsoft Form to your website using a QR code, link, or embed code. This step will vary depending on where you’re planning to display your form, and your chosen embed method. However, as an example let’s look at how you can embed this form in your WordPress website:
● In Microsoft Forms, select the “Share” button.
● In the panel that appears, select “Embed.” This should reveal an embed code.
● Click “Copy.”
● Log into your WordPress dashboard.
● Navigate to the page where you want to embed your equipment request form, and open that page for editing.
● Find the area where you want to display your form, and add a “Custom HTML” block.
● Paste your embed code into the HTML block.
● Publish or update this page, as normal.
Your equipment request form should now appear on your website.
How to automate your equipment approval workflow
In this section, we’ll create a workflow that extracts the information from each submitted form, and then emails it to a nominated individual or team. We’ll also create two emails that will be sent to your employees, depending on whether their request gets approved or denied.
● Log into your Microsoft 365 account.
● Select the “Power Automate” app.
● In the left-hand menu, select “Templates.”
● Search for the following template: “Start an approval process and send email on Microsoft Form submission.” Select this template when it appears.
● Read the description, and if you’re happy to proceed then click “Continue.” Power Automate will now open this template for editing.
● Let’s start at the top, with the “When a new response is submitted” field. Open the “Form ID” dropdown, and select the Microsoft Form we created in the previous step.
● Next, move to the “Get response details” box. Open the “Form ID” dropdown, and select your equipment request form.
● In the “Start an approval” section, you’ll need to specify the email of the person who submitted this form. You can pull this information directly from Microsoft Forms, using dynamic content. To open the dynamic content menu, click to place your cursor inside the “Requestor” field. This will open the “Dynamic content” dropdown.
You’ll now need to extract the requestor's email address. This step will vary depending on how you set up your Microsoft Form, but for me it means selecting the “Responder's email” value.
In the “Start an approval” section, you’ll also need to specify the approval type. Sometimes, you may want to share equipment requests with multiple people, for example your entire HR department, or the employee’s direct supervisor and your financial officer. If you require sign-off from all these people, you can select “Everyone must approve.” Alternatively, if you require approval from a single person only, select “First to respond.” You can then enter the email address of everyone who will receive this equipment request.
At this point, you can also provide several canned responses that the HR department or individual can add to their automated email response. For example, you might give the reponsder the option to choose between “approved,” “approved, pending more information,” or “denied, but please resubmit your request in the next financial quarter.”
You can create a custom response by selecting either “Custom Responses - Wait for all responses” or “Custom Responses - Wait for one response.” You’ll then get access to all the additional options you need, in order to create an automated response.
After entering this information, you can create the email that’s sent whenever a request is approved. You’ll need to start by specifying the employee’s email address. Here, we’re going to use dynamic content, so click to place your cursor inside the “To” field. This will open Power Automate’s Dynamic Content menu.
You’ll now need to retrieve the value the employee entered into Microsoft Forms. This step will vary depending on how you created your form, but for me this means selecting the following value: “Get response details: Responders’ email.”
After entering this information, you may want to customize the text that appears in the approval email.
Instead of sending the same auto-response to every employee, it may help to include some dynamic content. For example, you might include a list of all the equipment the employee has requested. You can pull this information from their Microsoft Form submission, by selecting “Add dynamic content.” You can then search for the field where the employee was asked to provide this information. For my form, this means selecting: “Please provide more information about the equipment you require.”
Once you’re happy with your approval email, you can move onto the “If no” box. You can now create the email to send whenever a request gets denied.
After creating your emails, you can verify that your flow is set up correctly using the “Flow Checker” and “Test” tools. Assuming there’s no issues with your workflow, your automated employee request platform is now ready to use.
Want more Power Automate workflows? Check out our step-by-step guide to building an automated work hours tracker for your remote workers.
Share this article on social media
If you found this article useful, please share it on social media.
Subscribe to our blog...
We will only use your email to send you new blog posts.
How to Build an Automated Customer Support Platform Using Power AutomateThe modern customer is demanding: if they have a question, they expect an answer immediately. According to research, 90% of customers rate a rapid response as “important” or “very important” when they have a customer service question. To help keep your customers happy, your support staff… Read More
How to create Intune device compliance policies for Android, iOS and WindowsBring Your Own Device (BYOD) has always been a huge risk to your business. However, 2020 was the year that many people worked from home. The has blurred the lines between work and home life – and personal and corporate data. After months of working… Read More
Don’t lose control of your data. How to create app protection policies.In 2020, the COVID-19 pandemic triggered a huge rise in remote working and forced many businesses to undergo rapid digital transformation. With more employees working from home than ever before, your employees likely have a wealth of company data stored on their smartphones, tablets,… Read More
How to create your own Microsoft Teams virtual commute, today. Have you been missing your daily commute throughout lockdown? Your immediate answer is probably a resounding: no. A survey by PowWowNow found that 45% of people spend over an hour commuting to work every day. Waving goodbye to the daily commute has long been perceived as one… Read More
3 Power Automate Templates to Improve Communication with Your Remote TeamsThe COVID-19 pandemic has changed so much about our lives, including how we work. Email and instant messages can help your teams feel connected, even when they’re physically apart. However, without in-person, real-time office communication, your staff may be starting to feel less connected. Is communication starting… Read More
How to Spot Suspicious Users. How to Deploy Azure’s Identity Protection.On average, hackers launch an attack once every 39 seconds. Malicious third parties pose a huge threat to your business. However, if you opt for a modern, cloud-based platform such as Microsoft 365, then you’ll have access to a range of security mechanisms and features that… Read More
Never Miss Another Deadline. How to Automate Your Microsoft Flow Planner.Project management can be a complicated juggling-act at the best of times. However, with many people continuing to work from home, project management may be proving even more challenging than usual. When it comes to project management, many businesses already rely on Microsoft Planner to help them… Read More
Has the COVID-19 pandemic changed the way we work, forever? Prior to the global pandemic, businesses were already investing billions into digital transformation. According to a report by the International Data Corporation, organizations were forecast to spend $1.18 trillion on digital transformation in 2019. Now, COVID-19 has fast tracked many businesses’ digital transformation. Projects that should have… Read More
Manage Your Remote Work Force. Create an Automatic Work Hours Tracker.Has COVID-19 changed the way we work, forever? If we take a look at some of the industry giants, then it seems that everyone is preparing their remote workforce for the long haul – and some are even giving employees the option to work from home,… Read More