Excel and autofill - how to turn it off

(1) Share

Report

Posted on by jhlavender

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.

All responses (2)

Answers (1)

jhlavender 8 on at

Like (1)

Report

Re: Excel and autofill - how to turn it off

Thank you for that. I did a lot of searching and that particular post never came up. I ended up solving the issue on my own by doing almost exactly the same steps.
Verified answer

Yutao Huang Microsoft Employee on at

Like (0)

Report

Re: Excel and autofill - how to turn it off

Hi @jhlavender - Please see if this thread helps: https://powerusers.microsoft.com/t5/General-Power-Automate/Updating-row-in-Excel-Table-with-HYPERLINK-works-but-also/m-p/864493