Hello,
I have been learning and working towards using more automate flows and see a lot of potential but feel past experiences using JavaScript programming has clouded my view as how a process should run, or flow... Puns aside, I have created a process where I would like individuals to submit issues using a form and I pull information from their response into a new sheet with 3 tables. The first table is their form response. The second table is who the issue is going to be assigned to based on their response using the send email with options prompt which is automatically sent when the form entry is put into the first table. The third and final table is for the resolution of the issue and will be based on a prompt within an email as well.
Originally I would have liked to do this with buttons within Excel online (one to assign and one to close) but could not figure out how to format and associate them with script files and I could not find a good prompt option in TypeScript. My question here is how I would associate the row from the first table that generates the email and places the response in the second table within the same row. I have a unique ID I am using in table 1 but the flow errored out when I tried to use it. I will then repeat this process for the resolution portion if this the best method of completion. Any assistance or suggestions would be greatly appreciated.
Thanks,
Ryan
