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 / Get work Item children...
Power Automate
Unanswered

Get work Item children status and work hours when parent task is closed

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

whenever a parent item is closed ,I am trying to fetch the work item children status and work hours. If any child item is not in done state, I will notify the parent item assignee to about closing the child task.

 

Steps I have taken,

1. Trigger : When work Item is closed.

2. Action : Send an Http request to Azure dev Ops.

Azure devops requestAzure devops request

Here i am trying to fetch all the child item for Work ID: 115968 (Also tried Dynamic Field. ID) but it is failing at this step only with error : "Unable to parse Base64 encoded bytes. clientRequestId: d86b2ede-c91b-4031-beaf-ef2773b9fb79"

 

Then I storing this query in to variable and

3. Using action : Get Query Results.

4. Apply to each : Send an email if state is not closed.

 

Any help is appreciated to resolve this issue.

 

Thanks,

 

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,189 Most Valuable Professional on at

    Hi @RK_RPA,


    As far as I am aware Query by WIQL request are POST requests and not GET requests.

    https://learn.microsoft.com/en-us/rest/api/azure/devops/wit/wiql/query-by-wiql?view=azure-devops-rest-7.0&tabs=HTTP

     

    Can you try something like below?

     

    {
     "query": "SELECT [System.Id],[System.AssignedTo],[System.State],[System.Title],[System.Tags]
    FROM workitemlinks
    WHERE ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward')
     AND ([Source].[System.Id] = '@{triggerOutputs()?['body/fields/System_Id']}')"
    }

     

    querybywiql.png

     


     

    Happy to help out 😁

    I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

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 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard