cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

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. 

 

2020-09-04 11_09_51-Edit your flow _ Power Automate.png

 

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'
 
FIRST LINE SUBMITTED.png
 
Second line submitted has the correct link:
 
SECOND LINE SUBMITTED.png

Happy to share any more details and thanks in advance!
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

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']

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

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']

View solution in original post

Highlighted
Regular Visitor

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.😊

Highlighted

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!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (9,281)