Case Study: Sarota PR achieves triple media-contact growth and rapid tender responses with Microsoft Power Apps

Sarota PR customizes Office 365 to generate data-driven business growth

Sarota PR, a Krakow-based public relations firm serving the tech sector, faced a patchwork of non-integrated third-party tools for managing media contacts, slow publications tracking and reporting, and a lack of real-time data insights. To address this, the company turned to Microsoft Power Apps and the Office 365 ecosystem—using SharePoint Online, Microsoft PowerApps, Microsoft Flow, Outlook actionable messages, Excel, and Power BI—to build a tailored, cross-application solution.

Using Microsoft Power Apps and other Office 365 tools, Sarota PR developed "Relations": a customized SharePoint contact database, a gamified mobile app (built with PowerApps and Flow) to capture contacts, Outlook actionable messages for quick approvals, Excel scripts for placement tracking, and Power BI dashboards for campaign analysis. The solution tripled the growth rate of the media contacts database in under a year and cut response times to new tenders from days or weeks to hours, enabling Sarota PR to deliver faster, data-driven strategies to clients worldwide.

Sarota PR

Karolina Pluta

PR Specialist and Relations Developer