I have a flow that is adding rows to a table in an Excel file stored on SharePoint. One of the columns is a link that has an ID embedded in it. The expression in looks like this:
=HYPERLINK("https://app.random.com/contacts/81253", "View")
When I run the flow, the first row is added just fine. When I add the next row, all of the rows ABOVE that row have the link changed to match the one I just added. That happens each time I add a row. So, at the end, if I have 28 items in the table, all of the links are identical and match the final row.
I think it's related to auto-fill. I know how to turn off the auto-fill function in the Desktop version of Excel, but I don't have the same capability in the web-based version. I've tried clicking the "Edit in Desktop Excel" option, turning off the auto-fill function, then saving it, but that doesn't change anything.
I'm completely stumped.
