cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EGILES
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
Michael_Shen_JT
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

5 REPLIES 5
Michael_Shen_JT
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

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

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
New Member

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
Advocate I
Advocate I

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.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (74,777)