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.
|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:
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.
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-overwr...
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.