Unanswered

Displaying SharePoint Attachment Links as List in DevOps Feature

(0) Share

Report

Posted on by vvSTRIDEvv

I have a flow that creates DevOps Features, by way of a Power Apps form and SharePoint list. Everything works ok except for 2 things.

1. The for each loop to get the links is causing duplicate feature creation (one for each attachment link)

2. The links are not hyperlink

I want to somehow concatenate the links to just one feature. Curious if anyone has some more info, thanks!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@vvSTRIDEvv

Please share screenshots of your flow and how it is structured.

Was this reply helpful? Yes No
vvSTRIDEvv 17 on at

Like (0)

Report

@Mira_Ghaly I'm triggering the flow based on a 'Status' change within the list. Then Initializing the Variable "SharePointAttachmentURI'
Then I am getting the Absolute URI's, which I want to show more than 1. Currently It only shows the last link, I want to show them all. The link is also not a hyperlink, which would be a nice to have.
From there I am creating the feature, outside of the loop.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@vvSTRIDEvv

Since you are creating the feature outside the loop so are you still getting duplicate features?

If yes can you check the history to understand if there is more than one instance running per same item in SharePoint..if yes that means that the issue is in the flow trigger..

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@vvSTRIDEvv

Can you please check this video that explains how to trigger a flow on a sharepoint column change.

https://youtu.be/xvmi21KomK0

Was this reply helpful? Yes No
vvSTRIDEvv 17 on at

Like (0)

Report

Thanks! I am not getting duplicates anymore, I apologize I should have specified. After the initial post I moved the feature creation out of the loop. The trigger is working perfectly and I am creating one feature per run. Just the attachment link giving me the trouble.

Was this reply helpful? Yes No
vvSTRIDEvv 17 on at

Like (0)

Report

@Mira_Ghaly Ok, I have the attachments links working somewhat. Here is what I did:

Then out side the loop, I append the variable:

Concat = concat(outputs('Get_URL_From_Loop'),';')

This gets me the multiple links, the problem I have is that the links do not come through cleanly. They have '[' and "" around them, and they are not clickable.

Here is what the links come through as currently:
["https://software.sharepoint.com/sites/Metrics/Lists/Enhancement Submissions/Attachments/3/Customer List for SharePoint.xlsx","https://software.sharepoint.com/sites/Metrics/Lists/Enhancement Submissions/Attachments/3/Small.png"]

What can I do to clean them up?

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report
@vvSTRIDEvv

Apologizes for the late reply, I have tried the below on my side and it worked.

1. Initialize string variable after Get Attachments and before the Loop

2. In the Loop , Add the action append to string variable with below Expression and then pass the URL Arrays String to the Work Item Description body

concat('<a href="',item()?['AbsoluteUri'],'">',items('Apply_to_each')?['DisplayName'],'</a>','<br/>')

This is the output on the work item

Hope this works for you as well!

Was this reply helpful? Yes No
vvSTRIDEvv 17 on at

Like (0)

Report

Works Perfect!! Thank You!!!

Was this reply helpful? Yes No