Power Platform Community Forum Thread Details

Hello,

I've recently started having issues with some very simple flows that have previously worked for years. The flow is - List rows from an Excel table, Apply to each, condition applied to take action on certain rows. In this exact case, when the condition is "true", it sends an email. My excel table cell formats have been set to "General" and I usually have 3 conditions (AND) in this specific flow. I use dynamic values. Again.. very simple.. This flow (and other similar flows) have all of a sudden stopped working in the last month. Today, I've tried several things... I've set the columns used in the conditions to "Text" instead of "General" format - didn't work. I've added compose steps before the condition -- those returned values as expected. I've recreated the flow from scratch. Also, to note, I have always used the "New Designer" view in the Power Automate web app. The only thing I finally got to work was to no longer use Condition and instead have 3 "Filter array" steps before the Apply to Each loop. Yes - that works, but feels like a poor solution - when Condition worked great (and gave options for AND or OR) previously. Has anyone else seen this?

Categories:

Building flows

Hi SM-26031910-0 ,

Thank you for choosing Microsoft Community.

Your flow is failing because of a recent bug in the new Power Automate designer that breaks Conditions using Excel dynamic values; the fix is to use Expression‑based string() comparisons or Compose outputs instead of raw dynamic tokens.

Alternatively, have you tried switching to the Classic Designer?

I hope these steps help resolve the issue! If you need more specific guidance, feel free to ask.

Happy to help

Robu 1 👩‍💻

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.