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

All responses (2)

Answers (0)

PowerApps999 62 on at

Like (0)

Report

Re: Concat hyperlinks with 'Update a Row' function

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?
Unknown geen idee 1,755 on at

Like (0)

Report

Re: Concat hyperlinks with 'Update a Row' function

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

Community site session details

Concat hyperlinks with 'Update a Row' function

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Concat hyperlinks with 'Update a Row' function

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates