Trying to create a flow that takes new incoming email and add it to an Excel table. The flow for 'add email to a table' works. That scenario is not sufficient because there will be Reply and Fwd to the email. So I have to find a way to create an update flow. I created a separate flow to "Update a Row" and I used expression to remove "Re:" and "Fwd" so that It can update the row in the table. It works. The problem is I have the 'Add row to a table" and that runs in the background and will keep adding a row, regardless that the 'update row' is doing as expected.
I created a new flow and used "Apply to each" @{array(triggerOutputs()?['body'])}. Then the next step is to Get Row and I set the Key Column 'Subject' and Key Value is @{triggerOutputs()?['body/subject']}. The Subject has to be the key for update an add. If the email is a reply/response, then it will update the row in the table that has the subject. If it's an initial (new) email, then it will add it. The flow is failing on the Get Row and I can see why because it does not find the Id that has the subject, for example subject is Test Email.
How do I resolve this? I have done so many variations and this is the last and I'm out of steam and not able to find any examples that talks about how to add an initial email to an excel table and update the excel table when there is a reply or fwd of the email. I need and appreciate all help.
