Check if multiple Dataverse rows equal a certain status

[powerwood]

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.

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]

Hi @powerwood 

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

Thanks

[powerwood]

@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]

Hi @powerwood 

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

[abm]

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

[powerwood]

@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 · Accepted solution]

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

[abm]

Hi @powerwood 

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

Thanks

[powerwood]

@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]

Hi @powerwood 

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

Thanks