Power Platform Community Forum Thread Details

Hello,

I want to send different emails to a number of people based on the value in a specific column (in this case column PC of the attached Excel), but in the Switch action I cannot get the Case actions to recognize the values.

When I put in 119 (example) in the Equals field of the case the ForEach action fails and when I put '119' in the Equal field the flow runs till the end, but no mails are sent since the case action does not seem to recognise the value.

Attached a copy of te Excel used and the flow.

Hopefully someone can help me figure out how to get the Case action working.

Thanks a lot!

Wim

TestWPL.xlsx

Multipleemailsvia...

Categories:

Building flows

Hi @WP-20021244-0,

Convert Excel Number to Text IN Switch "On" field, use string(items('Apply_to_each')?['PC']) expression. Excel numbers have hidden decimals ----- text fixes matching.

Use Exact Case Values Put 119 (no quotes) in Case "Equals" field. Switch compares same data types now. Test with Compose action first to see real PC value.

Check Run History Data Type Run flow, click failed ForEach. Check raw PC column value ---- copy exact format to Case. Often shows 119.0 not 119.

Delete Switch Instead of Switch Replace with Conditions string(items('Apply_to_each')?['PC']) equals '119'. Copy for each value

Note: Condition is more reliable than Switch

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz