Power Platform Community Forum Thread Details

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!

Categories:

General topics

Hi @Poppy123 ,

A recommended solution would be to start with a completely empty Excel workbook and as each location completes the form, a new row is added to the sheet; at least that is the way I would set this up. I would set up the form with a drop down question type where the manager selected their location with the other details in questions as needed.

Ok, how to easily see who has completed the fire drill or not? Use your existing worksheet (the one with all the locations already populated) and simply do a quick XLOOKUP and see if the test has been completed or not.

You COULD update a row but will need a key for the row and the effort to do is far greater than just adding that XLOOKUP to your existing worksheet to see who has completed and when. Again, that's how I would solve this if Ops came to me and asked for a solution.

Please mark as a solution if this was helpful! Always glad to help! Tom