
Announcements
Hi guys,
I am trying to use a Form where a user submits a text field containing a number and I have an Excel file that has a formula where the number needs to be plugged in to calculate a result (vlookup). Once the result is calculated, I would like to get that result back to power automate so it can be stored.
I tried using a MS Form and Excel Online to save the records into rows, but I don't know how to take newly created cells into the Vlookup formula.
Hope that made sense.