how can I add MULTIPLE attachments shared links in approval email onedrive not share point

[Alicito]

Hi there, I have tried to find a solution but can't seems to figure it out.

Flow is used to create reimbursement form that trigger and upload the attachments to onedrive, then a flow to create a shared link to send the manager to approve the request then store all data in sharepoint if accepted by manager. I can only add one link in the item link to send the email approval request ( where Im uploading up to 10 attachments in form ) 

I need to be able to send the link for all the uploaded attachments or if I can attache the attachments to the email. 

Look at the flow video to see the flow 

https://imgur.com/azwDpQa

Process: 

1. When a new response is submitted

   1. Get response details
   2. Parse JSON ( Upload file from form) Schema generated with 5 attachments 
   3. Get file content using path ( /Apps/Microsoft Forms/Concern Form/question/ " Query is called name" )
   4. Create share link by path (Apps/Microsoft Forms/Concern Form/question/ " Query is called name")
   5. Get manager (V2)
   6. Create an approval 3 ( Item link = link)
   7. then create everything in sharepoint if true.

      

[efialttes]

Hi

You need a workaround

Do you store all attachments in the same SP library? If so, do they share a common metadata value, so we can identify them amongs others?

If so, you just need to rebuild your link, so it points the sharepoint library filtered by the unique metadata value identifying all your attachment files

Hope this helps

[Alicito]

Wo What I understand from you is, when the form is submitted. create an item in sharepoint list with the attachments, then extract the link from there and add it to the approval card?

Do you have a link to do that? I can't seems to know the process of that. 

Thanks 

[v-bacao-msft]

Hi @Alicito ,

The first thing we need to know is whether the forms you create are Group form or personal form, which determines where the uploaded attachments are stored.

It also determines which connector we need to use to get the attributes of the file.

If the form is a Group form, you can refer to the following link to get the file:

https://powerusers.microsoft.com/t5/Building-Flows/O365-Group-Form-responses-with-attachments-to-Sha...

If it is not a group form, you can refer to this video:

https://www.youtube.com/watch?v=Foy8i6jPZrg

Please tell us the specific details so that we can provide a suitable solution.

Best Regards,

[Alicito]

Thanks for your replay, the for is personal, and files stored under one drive for the system user, then saved in share point

[v-bacao-msft · Accepted solution]

Hi @Alicito ,

You could refer to the following method to add File link to Approval email, but if there are multiple links, you can only configure them in Details. You can format the details using MarkDown.

Best Regards,

[Alicito]

Appriciate your help and the time you spent.

[knandez05]

Thank you for this solution @v-bacao-msft . This worked for me however the file hyperlinks are back to back in the approval email making it difficult to identify that they are multiple attachments. Is there something I can do to identify them separately?

Here is the Approval email setup:

[KolKedo]

Hello everyone,

I have the problem,  that the links in the email cannot be clicked.

Problem is on Outlook web, Outlook desktop. 

Does anyone have an idea for me?

[nk4]

Hi @knandez05 ,

You can simply press the Enter key from keyboard for the "Append to string action" like below.

It won't be visible but it will work in approvals.

This is how it will show in approvals if we add enter in the beginning of the "Append to string action".

Please consider this as an solution so that it will be helpful for other users.

Regards,

Nayana Kharatmal