'ADD A ROW TO A TABLE' step with a hyperlink overwrites all other rows hyperlinks

[EGILES]

Hi 

I am having an issue with the 'add a row to a table' step in excel. I have it set up so one of the columns creates a hyperlink to a file saved in sharepoint. However, if there are any other rows in the table with a hyperlink it overwrites it with the new one. All other columns have the correct values. 

The expression for the Link to image/doc: 

concat('=HYPERLINK("',triggerBody()?['Attached_x0020_data'],'","Click Here")')

EXAMPLE OF ISSUE:

First line submitted file name should be 'FIRST LINE SUBMITTED'

Second line submitted has the correct link:

Happy to share any more details and thanks in advance!

[Michael_Shen_JT · Accepted solution]

that's the expected result i believe, you can check the run history to check if the value in trigger body match the value in excel formula

triggerBody()?['Attached_x0020_data']

[abhi0698273]

As It is observed, CreateHTMLTable converts < to &lt; and > to &gt; when reading data from array, as it considers < and > as a input data.
While to have <a> markup to work, replace approach works every time.

Example Table contains -

{
...
link : "<a href= \"https://samplelink.tonewplace.com/person\">click here</a>"
...
}

gets converted to something below due to CreateHTMLTable -

<tr>&lt;a href= &quot;https://samplelink.tonewplace.com/person&quot;&gt;click here&lt;/a&gt;

So, When we replace as said earlier
Example table becomes -

{
...
link : "::a href= \"https://samplelink.tonewplace.com/person\":;click here::/a:;"
...
}

After CreateHTMLTable, result is similar to  -

<tr>::a href= &quot;https://samplelink.tonewplace.com/person&quot;:;click here::/a:;

So, now using Compose to replace the combination of characters, used earlier -

<tr>::a href= &quot;https://samplelink.tonewplace.com/person&quot;:;click here::/a:;

becomes -

<tr><a href= &quot;https://samplelink.tonewplace.com/person&quot;>click here</a>

Now above result can successfully be used as part of email.

This solution worked perfectly for me.😊

[EGILES]

Thanks for the reply, if the expected result is to overwrite all the hyperlinks in all the tables's rows how do I change it so that it just adds the hyperlink in the new row? Leaving any existing rows with the previous link?

Thanks!

[kotschyz]

Hello,

A same situation here.

I don't know how would this the expected result from a function named "ADD A ROW".

But OK, as EGILES already asked, what is the solution to our expectations? 🙂

Thank you in advace

[burrisca]

In my run history, each 'Add a Row' has a different hyperlink, but when I open the file they are all the same as the last hyperlink. And on top of that, when I change one they all change.