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 ! 🙂
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.
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?
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.
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.
May be using SharePoint Share link is more easy ?