Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / I am having an issue t...
Power Automate - Building Flows
Answered

I am having an issue trying to get my Filter Array action to work.

(0) ShareShare
ReportReport
Posted on by G0Springs 134

G0Springs_0-1636972463803.png

I am trying to create a flow which will create a new bucket in Tasks and Planner when a new work item is created in the Milestones app which is assigned to a new bucket that does not yet exist in Planner. 

 

Currently trouble shooting has made me aware as to why all the buckets are being created again and again despite the filter new buckets action roll is to prevent pre-existing buckets from being generated. This being that the Two Outputs are always different regardless of if their suppose to be the same.

 

Here is an example for a bucket called System deployment:

"Project Bucket": "System Deployment" G0Springs_1-1636972677711.png "Bucket Name": "{\"Project Bucket\":\"System Deployment\"}"

 

The output of the Select new bucket action for the dataverse is on the left of this equation and the output of the select existing buckets action for planner is on the right.

 

Is their a method I can employ to make these two the same?

 

Categories:
Business Process Flows
  • G0Springs Profile Picture
    G0Springs 134 on at
    Re: I am having an issue trying to get my Filter Array action to work.

    @Expiscornovus 

    For the 'Filter new buckets' action can I confirm that the From Parameter is Output body('Select_new_bucket') and In advanced mode the Filter is @not(contains(body('Select_existing_buckets'), item()))

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 32,102 Most Valuable Professional on at
    Re: I am having an issue trying to get my Filter Array action to work.

    Hi @G0Springs,

     

    I would remove the label in the mapping of both selects (use Switch Map to text mode button next to the map field). This way you could use an item() in the filter array.

     

    Below is an example of that approach.

    In the filter array I am using Body('Select_existing_buckets') does not contain item() to filter the body('Select_new_bucket') output. Btw, in the first Select I am using a SharePoint list as an example. I was too lazy to create a custom table in Dataverse 😅

     

    except_approach.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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans