Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on by 38

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 ! 🙂 

  • Verified answer
    Alexandra7 Profile Picture
    Alexandra7 38 on at
    Re: Create a One Drive Share link that contains all files input in one FORMS question

    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.

  • Alexandra7 Profile Picture
    Alexandra7 38 on at
    Re: Create a One Drive Share link that contains all files input in one FORMS question

    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?

     

  • Jdelavega Profile Picture
    Jdelavega 106 on at
    Re: Create a One Drive Share link that contains all files input in one FORMS question

    @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.

  • Alexandra7 Profile Picture
    Alexandra7 38 on at
    Re: Create a One Drive Share link that contains all files input in one FORMS question

    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.

    Automatisation des dérogations déviations.png

    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.

  • Jdelavega Profile Picture
    Jdelavega 106 on at
    Re: Create a One Drive Share link that contains all files input in one FORMS question

    Hi @Alexandra7 

     

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

  • Alexandra7 Profile Picture
    Alexandra7 38 on at
    Re: Create a One Drive Share link that contains all files input in one FORMS question

    May be using SharePoint Share link is more easy ? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard