Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Filter Query created i...
Power Automate - Building Flows
Answered

Filter Query created items to get items

(0) ShareShare
ReportReport
Posted on by LostInTheSauce 39

I have a database setup within SharePoint to build a document using MS Flow.  I was able to perform the basic with no filtering however, I'm caught on the filter query.

List 1: Builds out Cost estimates: Field WR No (unique per entry)

List 2: Project Scope: Field WR No (same as above)

 

I started a Flow that say when an item is created in List 1, get information from List 2 to populate a word template (already built) and save it into a folder.

 

I need to filter List 2 to only return information that List 1 refers  to.  List 1 WR No eq List 2 WR No.

 

I have tried to control Condition, however, that doesn't work either.  I was trying to perform the filter at the get items level utilizing the filter querey.  I'm doing it at this level, since I will have multiple list filling out the work document template.

 

Please help!

  • yashag2255 Profile Picture
    yashag2255 24,442 Super User 2024 Season 1 on at
    Re: Filter Query created items to get items

    Hi @LostInTheSauce 

     

    While selecting from the dynamic content for I type in WRNo(actual title of column) eq then with help fro. Flow I look up the create items and click on WRNo. , you should wrap the value from the flow in single quotations as shown in my screenshot in the other response. please post a screenshot of your flow if it does not work. 

     

    Hope this Helps!

  • LostInTheSauce Profile Picture
    LostInTheSauce 39 on at
    Re: Filter Query created items to get items
    So I'm getting lost on how to set the filter. Every option I do it doesn't give me the correct output.
    Create item WRNo
    Get items WRNo eq create items WRNo
    Is there something I'm missing?
    I type in WRNo(actual title of column) eq then with help fro. Flow I look up the create items and click on WRNo. Shoukdnt that be it?
  • Verified answer
    yashag2255 Profile Picture
    yashag2255 24,442 Super User 2024 Season 1 on at
    Re: Filter Query created items to get items

    Hi @LostInTheSauce 

     

    Please refer to the following post. I have used Odata querying and it just similar to wht you need. 

     

    https://powerusers.microsoft.com/t5/Building-Flows/when-item-is-created-updated-that-item-based-on-another/m-p/293407#M30914

     

    Hope thsi 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!

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
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May 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 >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans