How do I have a unique ID generated for each Microsoft Form response submission and have that unique ID export to the excel spreadsheet with the submission response data automatically in the first cell in the same row as its respective response data in the excel spreadsheet? I believe I am on the right track in Power Automate but I can't figure it out.
For every new response for a Microsoft form, how do I update a cell in the same row of each response so that each response has a unique ID in its row? I created a variable for the unique ID, but how do I get that unique variable to populate next to every response in the excel spreadsheet? I believe I selected the "Key Column" I want the unique ID variable to populate, but I don't think a "Key Value" applies in this scenario since I want it to populate for each new response. Thanks