Blog Post

Microsoft Foundry Blog
5 MIN READ

Enabling SharePoint RAG with LogicApps Workflows

MaheshMSFT's avatar
MaheshMSFT
Icon for Microsoft rankMicrosoft
Feb 26, 2025

This blog post outlines a LogicApps workflow-based method to export documents, along with associated ACLs and metadata, from SharePoint to Azure Storage. Once in Azure Storage, these documents can be indexed using the Azure AI Search indexer.

SharePoint Online is quite popular for storing organizational documents. Many organizations use it due to its robust features for document management, collaboration, and integration with other M...
Updated Feb 26, 2025
Version 1.0
azure ai search
azure openai service
MaheshMSFT's avatar
MaheshMSFT
Icon for Microsoft rankMicrosoft
Jan 11, 2026

Hi, thanks for going through the blog post and your query.

The solution above has 2 workflows - Historic and Ongoing.
For the first time load (e.g. 1 million document scenario), the historic workflow should be used which employs a sliding time window approach to ensure compliance with SharePoint throttling limits by preventing the export of all documents at once, you can customise the sliding window increment to your preference (e.g. 1 hr, 8 hrs, 24 hrs). Once the history export is completed which may take some time, the Ongoing workflow should be enabled (historic should be disabled) to only export documents getting created on ongoing basis. 

For cost estimation, consider running workflow on small set of documents (e.g. 1000 or 5000) and extrapolate to get the indicative costs.

Since the blog was posted there have been a number of features we announced that can enable RAG on SharePoint, please check them out.

McNickSisto's avatar
McNickSisto
Copper Contributor
Jan 13, 2026

Hi MaheshMSFT​,

Thank you for your response. 

Given that my end of goal is indeed to enable RAG on SharePoint, I have looked at the different approaches. It seems that for now those solutions are not production-ready just yet (public preview). I also wish to keep a certain control over how documents are processed / indexed with Azure AI Search. My options are therefore the following:
1. Wait until SharePoint (Indexed) is production ready (but how long?)
2. Transfer SharePoint files to an Azure Blob, and use the blob with Azure AI Search (as discussed in your blog)

I'll go with Option 2 for now, unless something changes in the near future. 

For the Ongoing workflow, are you using the Delta graph API ? Could you export Documents from SharePoint to Azure Blob using ADF or Azure Synapse ? Why Logic Apps ? 

Best,