A fully automated XML ingestion and publishing workflow that processes uploaded files, renames them to a standardized format, and delivers them to a public-facing document library—eliminating manual intervention and ensuring timely updates to customer-facing content.
This project was built to simplify and standardize the process of publishing XML files required by a public-facing website. Previously, files were manually renamed, moved, and validated by multiple team members, creating bottlenecks and increasing the risk of errors. To solve this, I designed an automated pipeline using Power Automate and SharePoint Online.
The system begins with a dedicated drop-off document library where internal teams upload raw XML files. The moment a file arrives, a Power Automate workflow triggers and reads the file metadata, validates the filename and structure, and applies a consistent naming convention based on predefined business rules.
After processing, the workflow automatically moves the renamed XML file to a separate publishing document library—a location synchronized with a publicly accessible website. This ensures that updated files are available online within seconds of being submitted.
The automation eliminates manual handling, reduces errors caused by inconsistent filenames, and ensures a continuous and reliable flow of content updates to the public site. With this workflow in place, the teams involved gained a faster, more accurate publishing process with clear separation between staging and production environments.