I need to find a solution to connecting form responses to the same assigned row within Excel.
I have set up an employee ID that I have included into all my forms and inserted that into all rows within a employee database with Excel. However when people submit a form using a space, a capitol, the wrong employee ID, the flow does not work.
I have built the flow to get form responses, get a row, update the row with the form response details.
Does anyone have any suggestions of how I connect unique employee data to the same row with forms, automate and excel?