Unable to get dynamic values for DevOps work item

[michawa]

Hello, 

When iterating through a VSTS query, I would like to set some conditions that match the Title of the work item. I imported a work item from a coworker and the flow already has a condition that searches against Title. However, I am unable to see such an option when I browse the dynamic content section. I am able to copy and paste the dynamic content though. Any help would be appreciated. 

[yashag2255]

Hi @michawa , 

You can get the fields in the dynamic content tab when you choose the action "Get Work Item Details" and not the "List Work Item" action  (or any other way that outputs a List of Work items in the form of an array. A workaround for that is to create an action to "Get work Item Details" in the apply to each control and get the details. Please refre to the screenshot below:

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!

[michawa]

The list of work items I am getting is from the "Get Query Results" action, but I assume that your workaround should still work. However, what are you inputting for Work Item Id? I see that you are using a custom expression there to retrieve the id from the value. 

[yashag2255]

Hey!

Used this expression 

items('Apply_to_each')['System.Id']

Thanks.

[michawa]

Ok thanks! Is there a way I can browse the list of properties that I can accesss for a given item? (If I want to get Title but don't know that it is called System.Title)

[v-bacao-msft · Accepted solution]

Hi @michawa ,

You could execute Flow once and then observe the name of the property contained in Body inside corresponding action.

Also observe peek code is now a better choice, as below:

Best Regards,

[Anonymous]

Hi @yashag2255 

When a new email arrives then work item will create in ADO

When I emailed "help.ado@tally.com" then the work item creates automatically.

If I replied to that email then again ticket is creating(It will be a duplicate). But my requirement is when I replied to that email then it should update it in the Work Item discussion or description. How do I achieve this?

I tried this https://powerusers.microsoft.com/t5/Using-Flows/When-a-new-email-arrives-then-work-item-will-create-.... scenario but no luck, could you please help me to achieve my requirement.

[shiva_1910]

Hi I am new for Power Automate, I am trying to create/Update work items from excel spreadsheet. but I'm not getting dynamic content for for get work items I have added List work item action but there also we need to add work item ID but not getting dynamic content.

I have seen your post you have not explained how you can map list work items action fields, request you please explain how you can maped list work items ID