Conditional file attachment to email

(2) Share

Report

Posted on by hzamani

Hi,

I'm using the "Send an email (V2)" action to send an email when a form is submitted.

The form includes an optional field to attach files.

The flow works fine when there's an attachment but I can't get it to ignore attachment when there isn't any file attached.

The only way I can think of getting this done is to create multiple conditions and check if there's any attachments. If not, then using another version of "Send an email (V2)" action which doesn't have an attachment.

That's doable if there was only one file but my form includes multiple optional fields to upload files.

Is there any way to include an expression in the attachment section of this action like this?

What I have got there at the moment is this:

if(equals(body('Parse_JSON_-_Proposal_Content'), null), null, first(body('Parse_JSON_-_Proposal_Content'))?['name'])

But I'm getting an error saying an attachment can not be null or empty.

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (0)

PrasadAthalye on at

Like (0)

Report
Can you build expression like below ? If its empty I am returning string 'its empty', else actual value.

if(empty( outputs('Get_response_details')?['body/rb155ddff72364222b289b17c7727a3e9']), 'its empty', outputs('Get_response_details')?['body/rb155ddff72364222b289b17c7727a3e9'])

Was this reply helpful? Yes No
hzamani 26 on at

Like (1)

Report

Hi Prasad, thanks for the suggestion. This will also not work because if there's an attachment name, then there must be an attachment file content. I can attach a dummy file instead but this means the email will include an attachment whether or not form was submitted with an attachment.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report

Can you please clarify more what do you mean you can attach a dummy file ?

I guess you are looking forward to find out if attachment exist or not? I think there are only 2 possible scenarios. Either User can attach something OR leave it empty. Are you saying there exist third use case?

Was this reply helpful? Yes No
hzamani 26 on at

Like (1)

Report

I mean if I provide a dummy text for the file name, which you have in your formula ( 'its empty' ), then the Attachment Content would need an input ( a file ).

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Can you try to use null expression instead of 'its empty'?

if(empty( outputs('Get_response_details')?['body/rb155ddff72364222b289b17c7727a3e9']), null, outputs('Get_response_details')?['body/rb155ddff72364222b289b17c7727a3e9'])

Was this reply helpful? Yes No
hzamani 26 on at

Like (1)

Report

I did, as in my first post of this thread. It doesn't accept a null or empty value.

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Ok then I think you will have to use If condition block to check if following expression is empty or not...

outputs('Get_response_details')?['body/rb155ddff72364222b289b17c7727a3e9'])

then copy email action from If to else block.. Inside If, you wont add attachment and inside else you will …

For the email content, you can declare a variable and use it in both actions to refactor.

Was this reply helpful? Yes No
hzamani 26 on at

Like (2)

Report

Thanks. That is exactly what I'm avoiding to do. I have multiple optional file uploads in my form. So someone can attach a file to field 1 and not attach to 2 & 3 & 4, etc ,etc. Lots of combinations can happen and I'd need to create a Send email action for each. Which could be avoided if the Attachment field accepted a null / empty value.

Was this reply helpful? Yes No
AndreaMeras 14 on at

Like (1)

Report

Im having the same situation. Did you manage to solve it?

Was this reply helpful? Yes No
hzamani 26 on at

Like (1)

Report

Not really, I had to create multiple conditional checks and have a specific version of Send Email V2 for each scenario 🤢

Was this reply helpful? Yes No