Employee Knowledge Discovery and Search Assistant
A leading IT services organization improved employee knowledge access with a SharePoint-based AI assistant, reducing manual document search and review effort.
Business Process Challenges
A leading IT services organization in the USA managed employee information and business documents through Microsoft SharePoint. Employees regularly needed to access benefits information, workplace guidelines, IT standards, onboarding resources, and organizational policies. However, finding the right information required employees to manually search through SharePoint, open multiple documents, and review lengthy content, making everyday knowledge access slower and more dependent on knowing where information was stored.
Key challenges included:
- Time-consuming manual searches: Employees had to search SharePoint repeatedly and open multiple documents to find specific employee-related information.
- Difficulty finding information across documents: Relevant information was often distributed across different SharePoint documents, making it difficult to identify the right content quickly.
- Repetitive document review: Employees frequently spent time reading lengthy documents to locate small pieces of information needed for routine questions.
- Delayed access to knowledge: The manual search process increased the time required to access important workplace information.
- Dependency on content location: Employees often needed to know where specific information was stored before they could find and use it.
The organization needed a natural-language experience that could retrieve relevant information from SharePoint and provide reliable answers grounded in enterprise content.
Our Strategic Approach
Softree designed a centralized employee knowledge assistant using Microsoft Power Platform, with Microsoft Copilot Studio serving as the AI orchestration layer. SharePoint was configured as the enterprise knowledge source, while Retrieval-Augmented Generation (RAG) enabled the solution to retrieve relevant document content and use it as context for responses.
The implementation included:
- SharePoint Knowledge Configuration: Softree configured SharePoint as the primary knowledge source and structured the knowledge experience to prioritize relevant retrieved information while avoiding unsupported responses.
- RAG-Based Knowledge Retrieval: The solution used Retrieval-Augmented Generation to retrieve relevant information from SharePoint documents and provide grounded responses to employee questions.
- Conversational Power Apps Interface: A Power Apps Canvas application was developed to give employees a centralized conversational interface for asking questions and accessing enterprise knowledge.
- Copilot Studio Integration: Microsoft Copilot Studio provided the orchestration layer for the conversational experience and connected the employee interface with the underlying knowledge capabilities.
- Power Automate Integration: Power Automate and the Copilot Studio connector were used to pass employee messages to the AI agent and return the generated response and conversation context to the application.
- Conversational Document Modification: The solution supported document modification through structured Word templates using Plain Text Content Controls, allowing supported information to be updated and generated as an updated Word document.
- SharePoint Document Storage: Updated Word documents were stored back in SharePoint, keeping the modified content within the organization's existing document environment.
How we delivered it.
Explore the Solution Through visuals
What changed for the client.
The solution transformed employee knowledge access from manual SharePoint document searching into a conversational experience. Employees could ask natural-language questions, such as “How many PTO days do employees receive?”, and receive relevant information through the Power Apps interface.
Key outcomes included:
- Reduced time spent searching SharePoint: Employees could access relevant information without manually reviewing multiple documents.
- Faster access to employee information: Natural-language questions provided a more direct way to find workplace policies, benefits, guidelines, and other information.
- Improved knowledge discovery: Employees could retrieve relevant information based on their questions rather than depending entirely on document locations.
- Reduced repetitive document-review activities: The solution minimized the need to repeatedly open and review lengthy documents for common information requests.
- Improved employee productivity: Faster access to relevant enterprise knowledge reduced manual effort involved in routine information discovery.
- Centralized enterprise knowledge access: Power Apps provided a single conversational interface for accessing information maintained in SharePoint.
- Automated Word document updates: Supported document modification scenarios could update structured Word content and save the resulting document back to SharePoint.
The numbers behind the rollout.
The full integration layer.
Other engagements worth a look.
SQL Server to Microsoft Fabric Data Warehouse Migration
Modernizing an enterprise SQL Server data warehouse with Microsoft Fabric while maintaining data quality, performance, security, and reporting continuity.
Read case study→
Healthcare Billing & Denial Resolution Agent
A Singapore healthcare provider proposed an AI agent to streamline claim denial investigations, payer research, follow-ups, and specialist review.
Read case study→
Hospital Operations & Bed Management Agent
A UAE hospital network proposed an agentic AI solution to improve bed readiness, discharge coordination, patient transfers, and operational visibility.
Read case study→
Enterprise Lakehouse Power BI Migration Modernization Services
A U.S. retail and e-commerce company modernized its Azure data platform with Microsoft Fabric, unifying analytics workloads and improving data governance.
Read case study→
Azure Synapse to Microsoft Fabric Migration
Softree modernized an Azure Synapse environment by migrating data workloads, pipelines, Spark notebooks, OneLake, and Power BI dependencies to Microsoft Fabric.
Read case study→
Healthcare Data Validation and Quality Assurance
Explore an AI-powered healthcare data validation platform designed to test data integrity across patient records, lab results, and insurance claims.
Read case study→Frequently asked questions.
Build faster with a reliable offshore engineering partner.
Partner with Softree to accelerate product delivery, modernize enterprise systems, and scale with confidence.
What we offer
Offices
Bengaluru
11th Floor, Prestige Tech Park, Platina 2 · Outer Ring Rd, Kadubeesanahalli · Bengaluru, Karnataka 560087, India
Cuttack
PLOT B6-1628, SECTOR-10, CDA · Cuttack, Odisha 753014 · India
San Francisco
San Francisco, CA 94108 · United States
Got a question, challenge, or idea?
Fill out the form or pick a time on our scheduler.
30-min discovery call
Same Calendly as our booking page · instant invite