<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Kaspars</title>
    <description>The latest articles on DEV Community by Kaspars (@kaspars-sharepoint).</description>
    <link>https://dev.to/kaspars-sharepoint</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3655130%2Fb42659b1-35c8-4e2f-a7e8-561878a7b902.png</url>
      <title>DEV Community: Kaspars</title>
      <link>https://dev.to/kaspars-sharepoint</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/kaspars-sharepoint"/>
    <language>en</language>
    <item>
      <title>I built a private Copilot alternative that never lets your data leave your Microsoft 365 tenant</title>
      <dc:creator>Kaspars</dc:creator>
      <pubDate>Sun, 28 Jun 2026 08:21:34 +0000</pubDate>
      <link>https://dev.to/kaspars-sharepoint/i-built-a-private-copilot-alternative-that-never-lets-your-data-leave-your-microsoft-365-tenant-363h</link>
      <guid>https://dev.to/kaspars-sharepoint/i-built-a-private-copilot-alternative-that-never-lets-your-data-leave-your-microsoft-365-tenant-363h</guid>
      <description>&lt;p&gt;For the last while I've been building &lt;a href="https://ksj.lv/en/privault-copilot-alternative-microsoft-365/" rel="noopener noreferrer"&gt;&lt;strong&gt;Privault&lt;/strong&gt;&lt;/a&gt; — a private AI knowledge assistant that runs &lt;em&gt;inside&lt;/em&gt; a company's own Microsoft 365 tenant. No data leaves their Azure infrastructure. Think "Copilot alternative", but you own the deployment.&lt;/p&gt;

&lt;p&gt;Here's the architecture and the judgment calls behind it.&lt;/p&gt;

&lt;h2&gt;
  
  
  The problem
&lt;/h2&gt;

&lt;p&gt;Document-heavy orgs (construction, engineering, 50+ knowledge workers) want an AI that actually knows their SharePoint. The off-the-shelf answer is Copilot — but for many EU SMBs the blocker isn't capability, it's:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Where does the data go?&lt;/li&gt;
&lt;li&gt;Per-seat pricing that scales badly for occasional users&lt;/li&gt;
&lt;li&gt;"Own your deployment" vs renting someone else's black box&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  The architecture
&lt;/h2&gt;

&lt;p&gt;Everything runs in the &lt;strong&gt;client's own Azure tenant&lt;/strong&gt;:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Retrieval:&lt;/strong&gt; semantic search over SharePoint documents, every answer returns cited sources (Microsoft Graph for indexing)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Actions:&lt;/strong&gt; the agent drafts and sends email, creates tasks in Microsoft To Do, and reads calendar/meeting context — all via Graph&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Multilingual:&lt;/strong&gt; 90+ languages (the EU reality is bilingual users)&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Model:&lt;/strong&gt; Anthropic with a zero-data-retention agreement&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Documents never leave the tenant. Responses are logged and cited, which turns "is the AI trustworthy?" into something you can actually audit.&lt;/p&gt;

&lt;h2&gt;
  
  
  The judgment call: pro-code vs low-code
&lt;/h2&gt;

&lt;p&gt;This is where most "just use Power Automate" advice falls apart. Power Automate is great until you need real retrieval, custom tool calls, and control over how the model grounds its answers. That's an Azure Functions / Python job. Knowing &lt;em&gt;which&lt;/em&gt; one a given workflow needs is the whole game — and getting it wrong is how you end up with a flow nobody can maintain.&lt;/p&gt;

&lt;h2&gt;
  
  
  What surprised me
&lt;/h2&gt;

&lt;p&gt;The hardest part wasn't the RAG. It was &lt;strong&gt;grounding + citations&lt;/strong&gt; under messy, real-world input — bilingual requests, half-formed questions, documents that contradict each other. A demo that parses clean input is easy. Production is where the EU-data-residency-and-actually-correct part gets earned.&lt;/p&gt;

&lt;p&gt;If you're weighing a Copilot alternative where data residency and ownership matter, this is the shape of what's possible inside your own M365. More on &lt;a href="https://ksj.lv/en/privault-copilot-alternative-microsoft-365/" rel="noopener noreferrer"&gt;Privault here&lt;/a&gt;.&lt;/p&gt;

</description>
      <category>microsoft365</category>
      <category>ai</category>
      <category>azure</category>
      <category>rag</category>
    </item>
    <item>
      <title>How We Automate SharePoint and Microsoft 365 Workflows for Small Businesses</title>
      <dc:creator>Kaspars</dc:creator>
      <pubDate>Wed, 10 Dec 2025 10:30:34 +0000</pubDate>
      <link>https://dev.to/kaspars-sharepoint/how-we-automate-sharepoint-and-microsoft-365-workflows-for-small-businesses-18jm</link>
      <guid>https://dev.to/kaspars-sharepoint/how-we-automate-sharepoint-and-microsoft-365-workflows-for-small-businesses-18jm</guid>
      <description>&lt;p&gt;Many small and medium businesses still use Microsoft 365 and SharePoint only as simple file storage or document folders.&lt;br&gt;&lt;br&gt;
However, with the right configuration, SharePoint + Power Automate can replace entire manual workflows.&lt;/p&gt;

&lt;p&gt;Here are some examples from my recent projects:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;invoice approval flows built on SharePoint lists + Power Automate
&lt;/li&gt;
&lt;li&gt;secure document routing and version-controlled processes
&lt;/li&gt;
&lt;li&gt;automated notifications and task assignments
&lt;/li&gt;
&lt;li&gt;integrating Microsoft 365 with ERP systems
&lt;/li&gt;
&lt;li&gt;using AI to classify documents and validate incoming data &lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;These solutions reduce manual work, eliminate human errors and improve productivity inside an organization.&lt;/p&gt;

&lt;p&gt;If you're interested in practical automation ideas or need a Microsoft 365 / SharePoint solution for your company, this is my approach (in Latvian):&lt;br&gt;
&lt;a href="https://ksj.lv/sharepoint-un-microsoft-365-automatizacijas-risinajumi/" rel="noopener noreferrer"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://ksj.lv/sharepoint-un-microsoft-365-automatizacijas-risinajumi/" rel="noopener noreferrer"&gt;https://ksj.lv/sharepoint-un-microsoft-365-automatizacijas-risinajumi/&lt;/a&gt;&lt;/p&gt;

</description>
      <category>microsoft365</category>
      <category>sharepoint</category>
      <category>automation</category>
      <category>powerautomate</category>
    </item>
  </channel>
</rss>
