I have created a MS Form and used power automate to generate an email to targeted people with the information in the form. I now need to create a flow that will take the email response back from the individual and populate a key piece of information back into the excel online file.
For example, we fill out the MS form with all needed information to process an order. The power automate generated email gets sent to our customer service team. I'd like for their response back with the order number to populate the excel online file in a designated column. Is this possible thru power automate?
Yes, if you have a standard way to recognize the emails by header or body content, you can set up an Outlook rule to move them a specific folder, then have a flow that triggers on the email arriving in the folder evaluate the content of the email and update the Excel file using connectors or Run script to run an Office Script.