Answered

Create a One Drive Share link that contains all files input in one FORMS question

(0) Share

Report

Posted on by Alexandra7

Hi everybody !

I have created a feed in which I need to retrieve files that are inserted in a question.
I know how to put them as attachments by creating a variable.

But I'm trying to create a One Drive share link that contains all the files (max 5) to put it in a row of an Excel table.
I manage to create the share link but there is only one file linked to it.

Thank you for your help ! 🙂

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Alexandra7 38 on at

Like (0)

Report
Copy link

Link copied!

May be using SharePoint Share link is more easy ?

Was this reply helpful? Yes No
Jdelavega 106 on at

Like (0)

Report
Copy link

Link copied!

Hi @Alexandra7

Could you give me a preview of the flow to better undestand the issue?

Was this reply helpful? Yes No
Alexandra7 38 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jdelavega !

For the moment I do it like that.
The first red square : it's "Parse JSON ".
The second red square : it's "Apply to each" and "Add a row to an Excel table
The third red square: I add the link of the Parse JSON in the column I want.
The problem with this way of doing it is, for example, that if I have 4 files that are added in my FORMS, then I have 4 excel lines that are created.

I would like only one line to be created, and have my 4 links in the same box. Or better yet, I would like 1 link to my 4 files.
I don't know if this is clear.

Was this reply helpful? Yes No
Jdelavega 106 on at

Like (0)

Report
Copy link

Link copied!

@Alexandra7

If you want to store multiple values in a single variable, maybe you could try using an array with the 'append to array' action. This way, you can easily add new values to the array as needed.

Was this reply helpful? Yes No
Alexandra7 38 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jdelavega !

I already tried creating an array variable but excel rows only support string variables.

What about creating a csv table, do you think it's possible?

Was this reply helpful? Yes No
Verified answer

Alexandra7 38 on at

Like (1)

Report
Copy link

Link copied!

I finally found a solution that works for me.

I "Create a folder" Sharepoint > "Get file content" One Drive > "Create a file" Sharepoint in the previously created folder > "Create a share link" Sharepoint of the folder.
So I have a link to a folder that contains the files.

Thanks for the help
If you want to see a screenshot of my feed, you can ask me and I will put it up.

Was this reply helpful? Yes No