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.
Frequently asked questions.
Let's Start a Conversation

Extend Your Engineering Capacity.
Not Your Hiring Complexity.
Build, scale and deliver more with an engineering partner that works as an extension of your team.
What we offer
- Agentic AI & Automation
- Web Application Development
- Power Platform & SharePoint
- Data Engineering & Power BI
- Mobile App Development
HOW WE CAN EXTEND YOUR TEAM
AI ENGINEERING
- Agentic AI
- AI Automation
- RAG
MICROSOFT
- Azure
- Fabric
- Power Platform
QUALITY ENGINEERING
- AI Testing
- Security Testing
- Automation Testing
SOFTWARE ENGINEERING
- React / Next.js
- Node.js / Python
- FastAPI
CLOUD & DATA
- Azure / AWS
- Data Engineering
- DevOps
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
11th Floor, Prestige Tech Park, Platina 2 · Outer Ring Rd, Kadubeesanahalli, Bengaluru 560087
PLOT 5C/1283, SECTOR-10, CDA, Cuttack, Odisha 753014, India















