Answered

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

(0) Share

Report

Posted on by 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:

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.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

efialttes 14,756 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Alicito 38 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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-Sharepoint-List/m-p/463809#M55734

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,

Was this reply helpful? Yes No
Alicito 38 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (2)

Report

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,

Was this reply helpful? Yes No
Alicito 38 on at

Like (0)

Report

Appriciate your help and the time you spent.

Was this reply helpful? Yes No
knandez05 146 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
KolKedo 13 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
nk4 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No