Unanswered

Concat hyperlinks with 'Update a Row' function

(0) Share

Report

Posted on by PowerApps999

Hello,

I am trying to make hyperlinks of muliple attachments in SharePoint list and bringing them into a row in excel. My flow is:

concat('=HYPERLINK("',item()?['URL'],'","',item()?['Name'],'")')

Which brings me:

The 'select' brings me all the attachments, but in the 'Update a row' gets me only one attachments from the 'select' (see below)

This 'Update a row' has the concat function I mentioned above and only one attachment is turned into hyperlink. Can someone help me on what I am missing so that the updated cell shows hyperlink with all the attachments like this:

01234_test_001.jpg

01234_test_002.jpg

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report

Dear P,
I would advice against this solution you are trying to complete. It is never a good idea to mix different details/data in a cell. You would be better off by adding different columns which could cover all the various links or even better have different rows for different data combinations.

Having said this, I do understand that in some situations people mis-use excel as a display tool rather than data processing. Could it be that you are missing to seperate (&) the links in the cells? Please check out the link:
https://www.causal.app/excel/putting-more-than-one-hyperlink-in-a-cell

Hope this helps,
Koen

Was this reply helpful? Yes No
PowerApps999 62 on at

Like (0)

Report

Dear @Koen5 ,

Thanks for the info.

I dropped that plan and now I am trying your way to create a table that consists of the hyperlinks of an item attachment in different rows. Since I have multiple attachments, while I use add a row in a table step, it brings me only the hyperlink of last attachment in all the row. When I checked the flow, it shows me all the hyperlinks on 'add a row to a table' step but in the excel, only the hyperlink of the last attachments.

Do you have any idea on how to add the hyperlinks of attachments in different rows?

Was this reply helpful? Yes No