Unanswered

Add e-mail recipient by if statement

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a send email action and want it to check an array (attachments to the email) for a specific word (in filename), and if that exists, add an email to CC.

I'm not sure how to write it, concat was the closest thing to a "add text"-function I could find.

Spoiler (Highlight to read)

if(contains('BrandlarmVCCAtt'), 'SATS'),concat('nicki.vike@sats.se')

Any ideas on how to get it to work? Ideally directly in the CC-field with extra variables and Compose-actions.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

joelzehring 208 on at

Like (1)

Report
Copy link

Link copied!
I think you're on the right track. Just need to change the syntax a little.

if(contains(string(variables('attachmentArray')), 'BrandlarmVCCAtt'), 'name@test.com', '')

The if expression takes three arguments. In this situation, the first argument is the conditional presence of a substring inside a string is the condition. The second argument is what to return if the condition is true (an email string). The third argument is what to return if the condition is false (an empty string). Source: Reference guide for expression functions - Azure Logic Apps | Microsoft Docs

The contains expression takes two arguments. In this situation, the first argument is the string you want to search within, and the second argument is the substring you're search for. Source: Reference guide for expression functions - Azure Logic Apps | Microsoft Docs

I don't think you need to use the concat expression since the if expression is placed inline after a string.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hmm.. But the syntax for contains is:
contains('<collection>', '<value>')
And the name of the collection/array is 'BrandlarmVCCAtt' and the string to search for is 'SATS', so shouldn't it then be like:
if(contains('BrandlarmVCCAtt', 'SATS'), 'nicki.vike@sats.se', '')

Was this reply helpful? Yes No
joelzehring 208 on at

Like (0)

Report
Copy link

Link copied!
Thanks for that clarification... If "BrandlarmVCCAtt" is the name of a variable in your flow, then the syntax would be:
if(contains(variables('BrandlarmVCCAtt'), 'SATS'), 'nicki.vike@sats.se', '')

Was this reply helpful? Yes No