Send an email in a switch control with Excel datasource

[hantsjoel]

Hi all,

I'm having troubles with errors when trying to use Send an email (v2) inside a switch control:

Here is the edit screen:

I have tried

1. Deleting and re-adding the Outlook connector

2. Formatting the 'Compliance' and 'CardholderEmail' columns as Text

3. Formatting the 'Compliance' and 'CardholderEmail' columns as General

4. Formatting the 'Compliance' column as Number

Flow runs fine when I remove the Send an email action, so it's the email that's tripping me up.

Can anyone shed some light on this please?

Many thanks

Joel

[ChristianAbata]

hi @hantsjoel  this exception is an api error, please consider to open a microsoft support case.

[v-bacao-msft · Accepted solution]

Hi @hantsjoel ,

Please try the following method to solve this problem:

Best Regards,

[hantsjoel]

Thank you @ChristianAbata and @v-bacao-msft. I have submitted a support request but in the meantime I've applied your workaround, Barry, and it has fixed the problem. 

Cheers