Returning Links from a Flow that sends many SP attachments from 1 List item to SP Folder (Stuck)

(0) Share

Report

Posted on by Questionasking

116

Hi,

Below you will see a flow that looks at a sharepoint list

The trigger checks to see if there is attachments for an item and if so it moves them to a document folder and returns the link to that list item,

If i have multiple items however the flow will just keep copying over the previous link and the last attachment link is displayed

Id like to have all the links displayed and if possible shown as hyperlinks with just the attachments name,

Also ive got a few errors that im unsure of how to fix without making the flow not do what i would like it too at the bottom?

for flowforum.png

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: Returning Links from a Flow that sends many SP attachments from 1 List item to SP Folder (Stuck)

First, if you want all the links displayed as hyperlinks you'll need to add a Rich Text field and append each one as HTML to the field. Probably easier to build an HTML table with all the links in it and then save that to the RTF field.

For the errors I suspect the problem is that you are trying to update the item each time you loop and that is overwriting the previous entry. Also the delete attachment needs to be in its own separate loop after everything in the first loop is complete. That's why you are getting the errors. If you delete or change an item while the loop is processing it you will interfere with the loop. Logically you need to do something like this.

1) Get the attachments

2) Save each attachment to the SharePoint library as a file

3) Append the sharing URL for the file to a table.

Once you are done processing all the attachments

4) Update the item with the HTML table

5) Loop through the attachments and delete them.

Was this reply helpful? Yes No
Questionasking 116 on at

Like (0)

Report

Re: Returning Links from a Flow that sends many SP attachments from 1 List item to SP Folder (Stuck)

@Pstork1 wrote:
First, if you want all the links displayed as hyperlinks you'll need to add a Rich Text field and append each one as HTML to the field. Probably easier to build an HTML table with all the links in it and then save that to the RTF field.

For the errors I suspect the problem is that you are trying to update the item each time you loop and that is overwriting the previous entry. Also the delete attachment needs to be in its own separate loop after everything in the first loop is complete. That's why you are getting the errors. If you delete or change an item while the loop is processing it you will interfere with the loop. Logically you need to do something like this.

1) Get the attachments
2) Save each attachment to the SharePoint library as a file
3) Append the sharing URL for the file to a table.
Once you are done processing all the attachments
4) Update the item with the HTML table
5) Loop through the attachments and delete them.
Sorry, im struggling to understand 3) Append the sharing URL for the file to a table.

So do i have to initialize a variable? or something, sorry im self taught and flow just has me at a mental block with this one.

Could you pretty please with some sugar on top, put up a screen shot and breakdown that step for me?

3) Append the sharing URL for the file to a table.

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report

Re: Returning Links from a Flow that sends many SP attachments from 1 List item to SP Folder (Stuck)

The problem is everytime you update the SharePoint item you are going to overwrite the previous entry. That's why you only get one link. So you have to gather all the links up in some way and add them to SharePoint once. Since you want hyperlinks the easiest way would probably be to build an HTML table manually as a string variable. So you would initialize the variable at the top of the flow and then append the appropriate HTML to the string for each URL. That will include figuring out what the HTML anchor tag would look like for the url.

You might want to start with something easier like just appending a comma delimited list of the urls. Then once that works you can worry about adding the HTML formatting.

Was this reply helpful? Yes No