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.

Report
All responses (
Answers (