cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

how to add a condition to list out the close tasks in last week or for a day with count information

Hi, 

 

i am pulling data from ADO for the closed work items, every time I am getting a whole set of data closed until now. 

 

i want to set a limit of closed in last week or last month along with the count . 

 

can some please guide me if you know to set that 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: how to add a condition to list out the close tasks in last week or for a day with count information

Hi @v-locha 

 

You can create a query in ADO and then use the send http request to ADO : https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Create-Update-Parameterized-Querie... to get this. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Community Support
Community Support

Re: how to add a condition to list out the close tasks in last week or for a day with count information

 

Hi @v-locha ,

 

Please consider creating a query in the Azure DevOps portal to obtain work items that meet the specified conditions.

Create managed queries with the Query Editor - Azure Boards | Microsoft Docs

 

Then use the Get query results action in Flow to get the items contained in the specified Query.

 

Please take a try and feel free to let us know if you have any questions.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Dual Super User III
Dual Super User III

Re: how to add a condition to list out the close tasks in last week or for a day with count information

Hi @v-locha 

 

You can create a query in ADO and then use the send http request to ADO : https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Create-Update-Parameterized-Querie... to get this. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Community Support
Community Support

Re: how to add a condition to list out the close tasks in last week or for a day with count information

 

Hi @v-locha ,

 

Please consider creating a query in the Azure DevOps portal to obtain work items that meet the specified conditions.

Create managed queries with the Query Editor - Azure Boards | Microsoft Docs

 

Then use the Get query results action in Flow to get the items contained in the specified Query.

 

Please take a try and feel free to let us know if you have any questions.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (3,568)