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 / Check if multiple Data...
Power Automate - Building Flows
Answered

Check if multiple Dataverse rows equal a certain status

(1) ShareShare
ReportReport
Posted on by rbergan 199

I have a flow that triggers on a change in a dataverse table. 

 

I am working on two different tables (Projects and Bids). Projects and Bids are related in a one to many relationship. There can be one or more bids associated with each project.

 

The flow is triggered when a bid status is changed to "Closed" in the Bids table. I then have a step to list the rows in the Bids table that are associated with this Project.

 

Screenshot 2023-01-12 153629.png

 

When there is only one Bid associated with a Project, there is a step that changes the status on the Project. But when there are multiple Bids on a Project, the flow stops.

 

I want to continue the Flow so it checks the status of the multiple Bids and updates the Project accordingly. How can I do that? For instance, if one or more Bids is still "Open" then do nothing with the Project status. Or if the Bid change that triggered this flow is the last to be marked "Closed", then the Project status changes.

 

Any insight you might be able to offer would be greatly appreciated. Thank you.

  • abm abm Profile Picture
    abm abm 32,492 Most Valuable Professional on at
    Re: Check if multiple Dataverse rows equal a certain status

    Hi @powerwood 

     

    Yes I agree and its a bit misleading that flow designer allows to save the flow for multiple triggers. 

     

    Thanks

  • rbergan Profile Picture
    rbergan 199 on at
    Re: Check if multiple Dataverse rows equal a certain status

    @abm , 

     

    Thank you. I haven't created the flow yet based on your suggestion, but it makes sense to me and I will let you know if I have issues implementing it. 

     

    Thank you.

  • abm abm Profile Picture
    abm abm 32,492 Most Valuable Professional on at
    Re: Check if multiple Dataverse rows equal a certain status

    Hi @powerwood 

     

    How you progressing with this one? Do you need further help in this?

     

    Thanks

  • Verified answer
    abm abm Profile Picture
    abm abm 32,492 Most Valuable Professional on at
    Re: Check if multiple Dataverse rows equal a certain status

    Hi @powerwood 

     

    This is what you after:

     

    1) I want to continue the Flow so it checks the status of the multiple Bids

        Change the current condition to greater than 1

     

    2) and updates the Project accordingly. How can I do that?

    For instance, if one or more Bids is still "Open" then do nothing with the Project status. Or if the Bid change that triggered this flow is the last to be marked "Closed", then the Project status changes.

       (a) Declare a variable before the current IF condition called 'bidstatus' boolean data type

       (b) Add another IF condition under the current IF condition Yes step. Here check the bids status is open then set          to true. This stage flow will automatically construct an Apply to each loop for reading all the bid records from previous step.

        (c) Add another new IF condition below the current IF condition to check IF bidstatus is true then do nothing else add your rest of the business logic.

     

    Hope it make sense.

     

    Thanks

  • rbergan Profile Picture
    rbergan 199 on at
    Re: Check if multiple Dataverse rows equal a certain status

    @abm ,

     

    Thank you. But what then? How do I analyze the results? I'm guessing I put the multiple bid results into an array, but how do I analyze the status scenarios within the array?

  • abm abm Profile Picture
    abm abm 32,492 Most Valuable Professional on at
    Re: Check if multiple Dataverse rows equal a certain status

    I would suggest greater than 1 which is safe compared to equal to one.

  • abm abm Profile Picture
    abm abm 32,492 Most Valuable Professional on at
    Re: Check if multiple Dataverse rows equal a certain status

    Hi @powerwood 

     

    Yes it would but if there are no records then also it would fall under the no branch.

  • rbergan Profile Picture
    rbergan 199 on at
    Re: Check if multiple Dataverse rows equal a certain status

    @abm , 

     

    Thanks for the response. I'm interested in the other side of the equation. How do I look at the Projects that have more than 1 Bid. Wouldn't that fall under the "No" option of the answer to Bid = 1?

  • abm abm Profile Picture
    abm abm 32,492 Most Valuable Professional on at
    Re: Check if multiple Dataverse rows equal a certain status

    Hi @powerwood 

     

    Change your condition to greater than zero. Currently its looking for one record match only.

     

    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

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