Russet House (food processing) · Software Developer, part-time · Jan 2026 – present
LLM agents in daily use at a food plant
Daily useby plant staff, in production since January 2026
Internal company system, described in general terms. No names, usage numbers, screenshots, data or code.
Problem
Everyday questions were slow to answer. Finding the right document meant searching SharePoint by hand, and questions about sales meant combining Power BI summaries with ERP data, with no reliable way to aggregate it exactly as asked.
Constraints
- Inside the company’s Microsoft stack. Agents are built in Copilot Studio. Automations in Power Platform’s AI Hub prompt the agents alongside Power Automate flows.
- Company data. The agents work over the ERP’s data in SQL Server and over SharePoint and Teams.
- Daily use. Staff rely on the agents every day.
What I built
I deployed LLM agents in Copilot Studio that staff question in plain language. The agents connect to:
- ERP data in SQL Server, through stored procedures.
- Documents in SharePoint.
- Meetings in Teams.
Automations built with AI Hub and Power Automate also prompt the agents.
Results
The agents are in daily use. I don’t publish usage numbers for internal systems.
What went wrong and how I fixed it
I root-caused and fixed the agents’ production failures, from Microsoft Graph permission errors to a data-corruption bug.
What I’d do next
- Keep a fixed set of real questions with known answers, and re-run it whenever a stored procedure or prompt changes.
- Log each agent’s tool calls, so the next production issue is faster to trace.
Athmane Benarous