web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sync data between Jira...
Power Automate
Suggested Answer

Sync data between Jira and Excel

(1) ShareShare
ReportReport
Posted on by 8
Hello,
 
I am looking to sync or pull data from jira to my excel (located in share point). How can I keep the data updated in the excel as it updates in Jira.
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,433 Super User 2025 Season 2 on at
    Hi,
     
    Can you share with us what you did for Searches and which parts were confusing? 
     
    There are samples, but let me give you a high level
     
    Since you didn't say when/how/often etc that you want to do this, I will just give an example
     
    1. Read the Jira Documentation to make sure you can even do what you want, as you didn't give detailed enough details for us to say.
     
    After you do that and hopefully it gives you want you want
     
    2. Make sure you have an Excel file that is accessible from the Cloud, and already has a Table defined in it, where you want the data.
     
    3. Create a Manual Flow (for a test)
    4. Use the Jira Connector to pull data from Jira
    5. Use an Apply to Each Action to loop through the Data you got from Jira
    5c. Use a Get Item from Excel and create an OData Expression so that you only pull back the row you want
    5a. Inside the Apply to each add the Update a Row in the Table (Excel Action)
     
    Over all that's it unless you want to add logging or error handling
     
    Here are the documents for the Jira Connector to help you
     
    If you have any questions at all please come back and we can help you work through it.
     
    If you decide you want to Schedule the Flow, then please Select the SCheduled Flow Trigger, instead of the Manual
     
    Thanks!! goodluck
     
     
     
     
     
     
  • zeeman05 Profile Picture
    8 on at
    Hi @FLMike
     
    I am looking to pull data from the Jira Issues tab. The purpose is to pull any open ticket from the issues list and save it in the Excel table. I want to automate this in real time so that incase a ticket was solved it does not appear on the excel either. From the excel, I will be feeding the data to my MS PVA chatbot and display the data.
     
    I am stuck with the JIra and excel integration right now, the other part I got it figured out.
     
    However, if there is a direct route from Jira to PVA, please do let me know. Appreciate any samples if you have please.
     
    Thank you
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard