I'm trying to update an existing spreadsheet with forms and power automate. Ideally i want power automate to be able to find an existing row on a spreadsheet( or table if necessary). It would find the right row with data added in a form. Then to create a new column on that row with data added into the same form. I'm trying to create a fire drill log for several business locations. I have a spreadsheet with the name of each branch on a row and then want the manager at that branch to complete a form once the fire drill has happened which would then pull through and update my spreadsheet for me. I don't really want to do add a row as i want it to be easy to see which branches have completed the form and which are outstanding.
any suggestions would be useful, i'm fairly new to power automate so still learning!


Report
All responses (
Answers (