Unanswered

hyperlinks overwritten when adding row into table

(3) Share

Report

Posted on by rsymmons

222

When using the function "add a row into a table" and using the hyperlink formula to create clickable URLs to web locations, data entered into the hyperlink column is overwritten by the last submitted data.

E.g

Expected behaviour	Actual behaviour
URL1	URL Overwritten - NOW URL4
URL2	URL Overwritten - NOW URL4
URL3	URL Overwritten - NOW URL4

The expected behaviour is to create a unique URL when "adding a row into a table" but they are just being overwritten by the last submission. This happens for the entire column and not just the last entry.

This is the formula:

=hyperlink("https://**********.sharepoint.com/People%20&%20Culture@{outputs('Create_file_with_details')?['body/Path']}?web=1","Click Here")

Any suggestions?

Rob

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

rsymmons 222 on at

Like (0)

Report
Copy link

Link copied!

I think I've resolved this.

I managed to achieve the desired result by using the "Get file properties" function and then building the hyperlink using "link to item" to build the hyperlink formula.

Was this reply helpful? Yes No
rsymmons 222 on at

Like (0)

Report
Copy link

Link copied!

Oddly enough this stopped working this morning and the link column hyperlinks are being overwritten again. Help!!

Was this reply helpful? Yes No
burrisca 65 on at

Like (1)

Report
Copy link

Link copied!

I commented in another post, but this has been happening in my flow for awhile and can't find much on it. https://powerusers.microsoft.com/t5/Building-Flows/ADD-A-ROW-TO-A-TABLE-step-with-a-hyperlink-overwrites-all-other/td-p/678509

Was this reply helpful? Yes No