I've got several flows setup that use conditional checks, which are suddenly no longer working as of about a week ago. I've spent hours trying to figure out why, and I'm no closer to a solution than when I started. Basically I have two separate Sharepoint lists, one with tickets submitted through a Power App, and another that lists out admin users and what ticket queues they're responsible for.
I have several flows to support these operations:
- Sending an email to the admins of a queue when a new ticket is submitted to their queue
- Automated reminder of new tickets that haven't been updated in a week
- Automated reminder of in-progress tickets that haven't been updated in a week
Each of these has a similar function - they grab the full list of admin users, looping through each user and checking to see if the ticket's Queue is in the list of Queues each user is responsible for. If there's a match, they're added to the email.
Except suddenly the comparison check that sees if Queues contains Queue isn't working, even though I haven't touched the flows in months. Every user comes back false, regardless of whether or not they have the Queue in their Queues field. I've tried fiddling with the conditional check, using Queue Value instead, forcibly converting Queues and Queue to strings, etc., and nothing's worked. So now I turn to the wider community.
I'd definitely love to know why my flows worked fine for months only to suddenly stop. Makes me think MS changed something under the hood. But more importantly, I'd appreciate assistance on getting these flows working again.
Also, before anyone says "Why not use an ODATA filter instead of a loop?" I've also spent hours trying every possible permutation I can find on the internet, and all I ever get for my trouble is "The filter is not valid". But if there's a way to get that working instead, I'm all ears. Thanks.
