Introduction
Project Objective: Automate Jira ticket creation from new SharePoint list items and synchronize Jira updates back to SharePoint, including status changes, field updates, and attachments.
Problem Statement: External auditors required access to Jira ticket details for auditing, but Jira licenses were costly, and internal comments needed to remain secure. SharePoint was chosen as the interface for external auditors, with Jira reserved for internal updates.
Implementation
Tools: SharePoint, Jira API, Power Automate.
Key Actions:
- Automated ticket creation in Jira from SharePoint.
- Synced Jira updates to SharePoint with secure workflows filtering internal comments.
- Customized mappings to ensure seamless data flow between platforms.
Results
Impact:
- Reduced Jira license costs by 30%.
- Enabled real-time synchronization between SharePoint and Jira.
- Enhanced audit efficiency and maintained data security.
Conclusion
The integration streamlined collaboration and auditing by bridging SharePoint and Jira, delivering a secure, cost-effective solution for cross-platform data management.
