Unanswered

Store all URL of uploaded files in SharePoint list column

(0) Share

Report

Posted on by kinghnvn

I have a request form which gives users the option of uploading multiple files.

I am creating a flow to store these requests into a SharePoint list.

The file in the submitted MS form will be automatically saved in OneDrive. I would like the URL of this uploaded files to also be stored in the list (column name: "Link").

Above is my flows but it only store a URL in the Link column.

I would like to store all URL in the Link column. Hope someone can help me with this.

Thank you very much

@v-dezhili-msft

All responses (9)

Answers (0)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: Store all URL of uploaded files in SharePoint list column

Hi @kinghnvn ,

What type of column do you want to store the Url in, if it's just a text column you can try:

Best Regards,
Dezhi
kinghnvn on at

Like (0)

Report

Re: Store all URL of uploaded files in SharePoint list column

I suggest you go back to the previous post to get help with setting up the For Each. -> as Dezhi mentioned, He asked me to create a new post for this issue, so I created this topic 😞
AlexMCC 293 on at

Like (1)

Report

Re: Store all URL of uploaded files in SharePoint list column

I'm sorry, I can't help you with that part, since I'm not familiar with processing Forms data.

Did you not have a working For Each loop in the original post? Or was it not tested yet?

I suggest you go back to the previous post to get help with setting up the For Each.
Solved: Storing URL of multiple files uploaded via MS Form... - Power Platform Community (microsoft.com)
kinghnvn on at

Like (0)

Report

Re: Store all URL of uploaded files in SharePoint list column

I have just tried to update my flows, but it still not working.
AlexMCC 293 on at

Like (0)

Report

Re: Store all URL of uploaded files in SharePoint list column

You want to use the same value in the For Each as in your orignal post.

You also want to use your actual URL, not the Thumbnail. Sorry for any confusion, I added the thumbnail in my screenshot as example data, since I don't have a form set up.
kinghnvn on at

Like (0)

Report

Re: Store all URL of uploaded files in SharePoint list column

For Select an output from previous steps field, I could not find the "value" name
AlexMCC 293 on at

Like (0)

Report

Re: Store all URL of uploaded files in SharePoint list column

You must first initialize a variable outside of the loop.

Add a header in the initialize action, if you want. Then add a break character like a space, comma or line break as the first item in your Append action.
kinghnvn on at

Like (0)

Report

Re: Store all URL of uploaded files in SharePoint list column

I tried to add "Append to string variable" but cannot enter the Name, your advises please.
AlexMCC 293 on at

Like (1)

Report

Re: Store all URL of uploaded files in SharePoint list column

You are overwriting the same item in every loop of your For Each. Meaning you will always end with the URL to the last item.

In your For Each, combine the URLs using an "Append to string" or similar action.

Then, outside of your loop, update the row with this new combined value.