Approval Workflow - issue attaching more than one document when these are added in a file

[mbodero94]

Hi,

I am having trouble to set a workflow approval. When a file is added to a folder (submitted invoices) an approval process must start. I want all the files that are added to this folder to be attached in the email, but I don't know how to set it because I am finding an error message in the "append to array variable" when I'm testing it. Could someone help me, please? I am going crazy.

I am not sure If the information I am entering is correct.

Many thanks

[MarconettiMarco]

Hello @mbodero94 ,

please follow these steps:

When you add the "Append to array variable", please use the following expression for the Content:

body('Get_file_content').$content

Then, in the "Start and wait for an approval" action, click on this button, so that you only have to insert the Attachments variable instead of the 2 variables "Attachment Name" and "Attachment Content":

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[mbodero94]

Hi @MarconettiMarco ,

Now it works!!

Thank you so much for your help:)

Do you know if there is an option to be able to preview the attachments when sending it to Outlook? I can preview everything but the documents I sent through the Approval Workflow. Is it for a reason?

[mbodero94]

@MarconettiMarco 

This is how the docs look like when the workflow works: 

Is there a way that I can see it in the correct format?

[MarconettiMarco]

Dear @mbodero94 ,

are you able to see this option in Outlook within the Approval email?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[MarconettiMarco]

Dear @mbodero94 ,

which are the docs formats?

BR,

Marco

[mbodero94]

Hi @MarconettiMarco,

Yep I am able to see those options. But when I click in preview the below message appears:

I wonder if it is because I need to click something when I am creating the workflow?

My formats are PDF and excel 

[MarconettiMarco]

Dear @mbodero94 ,

please follow the instructions in this article:

https://thegeekpage.com/outlook-this-file-cannot-be-previewed/

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[mbodero94]

Hi @MarconettiMarco ,

Thanks for your amazing help. I have another question. I am trying to add another step to send a message in the teams chats similar to the below: 

However, one I am adding the "created by Display Name" and "Link to item", another "Apply to each" steps appear and I don't know how I have to do it. Do you have any idea how I should set this step? 

Many thanks in advance

[MarconettiMarco]

Hello @mbodero94 ,

I think you can easily initialize another Array variable, put inside your values, then Append to Array variable for each file that has been created, and finally add this variable in the email body.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[mbodero94]

Hi @MarconettiMarco ,

Would the below be correct? 

[mbodero94]

hI @MAR ,

I am facing now other issues. When I test the flow, instead of sending 1 email with the 5 attachments, it sends 5 emails (with the different file names on each email) but attaching all the files in each email. Why does that happen? Should I change in the append to array variable "Name" for an expression, so it list all the names of the files in the same email? Or how can I do it?

Also, If I add another step for "send email", would then the format of the file be the one I attach instead of being that weird format I shown you before?