I was doing some investigation on how I could automate some standard messages we send for my team related to some sprint tasks using Power Automate, and one simple requirement was to automatically detect the current sprint (iteration) name, to make an email content dynamic.
The problem
There is one action in Power Automate to get iterations, but it does not have a filtering option.
![](https://i0.wp.com/michelcarlo.com/wp-content/uploads/2024/03/list-iterations-1.png?resize=536%2C160&ssl=1)
We could leverage this one in combination with the Filter array action in Power Automate, but I was wondering if I could make it in a more performant way and with only one action.
The solution
Azure DevOps also has a Rest API that we can leverage to do actions that are not available out of the box.
We can run a query to get the current iterations using a GET request on the the Iterations endpoint, as below:
https://dev.azure.com/{organization}/{project}/{team}/_apis/work/teamsettings/iterations
And it has a parameter that allows us to receive only the current iteration:
Source link
More About This Author
![michelcarlo](https://i0.wp.com/365community.online/wp-content/uploads/2020/04/C6zQCIg6_400x400.jpg?resize=150%2C150&ssl=1)
-
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
Array
Modern Workplace24 July 2024Power Pages Table Permissions: Configure permissions to see records from child Accounts
Modern Workplace15 July 2024Copy Dataverse contact phone numbers across different environments based on Contact e-mail address using Power Automate
Modern Workplace1 June 2024Get the current logged Power Pages user Contact ID via JavaScript and use it to create records assigned to the current user
Modern Workplace11 May 2024How to get the current Azure Devops iteration name for a project using Power Automate