Excelerate your productivity by expanding your skills using common tools

Exceleration: Power Apps Get Sharepoint Data using Power Automate

I have explored enhancing Powerapps performance by using caching techniques with SharePoint REST APIs, avoiding the need for premium connectors. By leveraging three phases of logic—validating, updating expired data, and handling new entries—I optimized data retrieval. We implemented a “Power Automate” flow for fetching and caching SharePoint data. This facilitates smoother and cheaper operations within Powerapps, using conditions to manage data freshness and validity effectively.

Exceleration: Import JIRA data into Excel using Power Query and JIRA REST API

Create reports and inspect data from JIRA using Excel easily, efficiently and intelligently. JIRA by Atlassian may be the most popular Agile project management tool embraced by Scrum Masters, Product Owners, developers, testers and the organizations that depend on them. Excel by Microsoft is undoubtedly the most widely used spreadsheet (data analysis and reporting) tool used by leaders, communicators and basically anyone that uses a computer. What if you could have your Jira cake and eat it with Excel, too?