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

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

AlexMCC 293 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AlexMCC 293 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AlexMCC 293 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

I have just tried to update my flows, but it still not working.

Was this reply helpful? Yes No
AlexMCC 293 on at

Like (1)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

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 😞

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No