Project Summary

Enhanced Business Process Improves Data Quality, Organization, and Efficiency in Vendor Management System 

Enhanced Business Process Improves Data Quality, Organization, and Efficiency in Vendor Management System 

A full-service commercial real estate organization had difficulty managing vendor information and requests. Based on the volume of vendors and incoming submissions, it was challenging to keep everything organized, and the process had become increasingly manual. The client approached Imaginet to improve the vendor management process in their SharePoint Online site for them and their customers.  

The Imaginet Business Productivity team used Power Apps to create a front-end interface for the portfolio manager. Based on their business requirements, several form types were constructed (e.g., a new request, resubmit a request, deactivate a vendor, reinstate a vendor, update information, etc.). Once a form is submitted, it triggers an update to a SharePoint List, and the management team can modify, approve, or reject each submission or complete any missing information. We enabled a time stamp for attachments to ensure a historical record of new vendor form submissions. We also made it easy to view a complete list of vendors, creating a new layer of transparency and convenience for team members to search for vendors in a centralized location.   

Using Power Automate, we created an email template/flow that processes different requests based on the submitted request status. The flow updates the SharePoint List item based on each request and sends each result as an email template to the requester. A receipt generates for each vendor and necessary member of the management team. Based on this information and permission settings, management can determine who on the team will handle each request. 

The enhanced business process and permission settings enable the client to limit access to team members and provide users with a better experience to modify and submit requests. Imaginet helped the client update and automate many pieces of their manual process for vendor management, optimizing data cleanliness, organization, and efficiency within the company. 

Our team has been working hard to deliver exceptional results, and we are thrilled to share our success with you. Don’t forget to subscribe to our newsletter to stay updated on our most recent Microsoft 365 projects. Fill out the form at the bottom of the page if you would like to work with us and someone will be in touch.

Technologies Used

SharePoint helps improve vendor management process

discover more

SQL Saturday Part 2: Learning About Microsoft Fabric 

Mike DiehlFeb 29, 20246 min read

SQL Saturday Part 2: Learning About Microsoft Fabric   February 29, 2024 I’ve been digging into Microsoft Fabric recently – well overdue, since it was first released about a year ago. At the recent SQL Saturday Atlanta event I attended in…

Custom Application Streamlines Production and Reduces Costs

Imaginet Resources CorpFeb 27, 20245 min read

A well-known consumer packaged goods (CPG) company specializing in pet food contacted Imaginet to complete and polish a custom application started by a few interns. The application was not as far along as they initially thought, and they needed support.  …

My Trip to SQL Saturday Atlanta (BI Edition): Part 1 

Mike DiehlFeb 23, 20245 min read

My Trip to SQL Saturday Atlanta (BI Edition): Part 1  February 23, 2024 Recently, I had the opportunity to attend SQL Saturday Atlanta (BI edition), a free annual event for data professionals and enthusiasts held in Alpharetta Georgia. I spoke…

Let’s Build Something Amazing Together

From concept to handoff, we’d love to learn more about what you are working on.
Send us a message below or drop us a line at 1-800-989-6022.