Skip to main content
Community site session details

Community site session details

Session Id : aEa4C7wL6oQxpNsa2pRBgg
Power Automate - Building Flows
Unanswered

Create a azure devops work item on email but avoid duplicates

Like (0) ShareShare
ReportReport
Posted on 9 May 2023 02:03:45 by 11

I am trying to create a azure work item on email but wanted to avoid creating duplicate work items if a email arrives with same subject. 

 

I tried the below but the problem is for true it doenst do anything which is what i need but for "Get query results" give other items in the list which are makes the condition false creates more duplicates. Please help. Thanks in advance. 

 

hashik4d_0-1683597701658.png

 

  • hashik4d Profile Picture
    11 on 09 May 2023 at 19:42:50
    Re: Create a azure devops work item on email but avoid duplicates

    Hi @Expiscornovus,

     

    The solution works amazing. Thank you very much 🙂 

  • Expiscornovus Profile Picture
    32,169 Most Valuable Professional on 09 May 2023 at 07:53:21
    Re: Create a azure devops work item on email but avoid duplicates

    Hi @hashik4d,

     

    Try a Filter Array action instead of checking each individual item in a loop. This way you can check for all items at once.

     

    If that Filter Array action comes up empty you can safely create a new work item. You can use a length function in a condition for that check.

     

    Below is an example

     

    length(body('Filter_array'))

    is not equal to 0

     

    filterarray_approach_devops.png

     

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2