You’re offline. This is a read only version of the page.
Announcements
I am using power automate and using information that a user enters into a table from a Microsoft form. I have a VLOOKUP in the last column of the table that I want updated when a new line comes in. (The VLOOKUP is grabbing data from a static table)
the next part of the flow is to grab the information from the new line and send out a email with the data. Everything works perfectly but I cant get the vlookup formula to update automatically.
The VLOOKUP will work if I f2 into the cell and hit enter. I am struggling to make it work automatically.
Anyone that has a idea I would love some help.
So you're using Power Automate to add a new row, and the VLOOKUP just doesn't update? Interesting.
I wonder if pushing a data refresh on it would force it, as well? Because you can do that through an Office Script. https://powerusers.microsoft.com/t5/Building-Flows/data-connection-refresh-excel-with-flow/m-p/723770/highlight/true#M98902
Share
Report
All responses (
Answers (
8,690
