Flow creation

Hello,

I found a bug in our flow and I don't know how to fix it.

We have a flow in which the 'Active Cloud', 'Active Server', 'Active Backup' checkboxes on the Account object are set to true if the service status is Active.

If the status of the service changes to Inactive, these checkboxes change to false.

Flow does not work properly, because changing the status to Inactive, for example for Cloud, will mark the 'Active Cloud' checkbox to false, even though the Account may have 10 other active Clouds.

I would like flow to work like this:

Flow starts when a new service is created or an existing one is updated (status changes).

Then, if the status changed to Active, then set the 'Active ....' checkbox to true.

If the status has changed to Inactive, check if the Account has other services in 'active' status with the same Product Name. If not - set the 'Active ....' checkbox to false.