Updating Column from email changes

Help Studio
, , , , , ,
1

Hi everyone. So this is a weird one that has been bothering me for about a week, it seems easy, but I can’t figure it out.

I have an excel sheet with a bunch of columns, three of them being email sender, subject, and category.
Over time the categories of the emails change and I would like the bot to capture it.

Because there are so many emails I cannot just use get outlook message to update the rows.

I am trying to use the read range sender and subject to identify the same sender and subject in the email list to then see if the category has changed, if it has, then update the Category column using a Write Cell.

Any help would be appreciated.

2

Basically if there is a sheet with

Sender | Subject | Category
john test1 Blue
alex test 2
mike test 3 Red

and the categories have changed to

                                     Category 
                                   Blue, Pending 
                                      Orange 
                                       Red, Done

then the sheet should update to

Sender | Subject | Category
john test1 Blue, pending
alex test 2 Orange
mike test 3 Red, Done

3

@srobey97

For Each email In emails:
  TypeArgument: System.Net.Mail.MailMessage
  For Each row In dtEmails:
    TypeArgument: DataRow
    If currentRow("Sender").ToString.Equals(email.Sender.Address) AndAlso currentRow("Subject").ToString.Equals(email.Subject):
      If Not currentRow("Category").ToString.Equals(email.Headers("Category")):
        Assign currentRow("Category") = email.Headers("Category")
4

Hi, as I work on this could you elaborate on what “currentRow” is and now to write cell everything to the sheet? I’m still not exactly following the logic

5

@srobey97
Use row instead of currentrow

6

Here is the flow, it runs, but nothing gets updated.

forum
forum386×638 22.1 KB