Unanswered

Tracking emails based on conversation ID

(0) Share

Report

Posted on by Deepak7050

I have created a flow where it locates the conversation ID in excel and update the row, however when the conversation id is not found in the list, the flow will add a row in the excel sheet. when i am testing its working fine. however, if someone sends an email to the shared mailbox it does not update the row for the same conversation ID, but it logs new row in the spreadsheet. please advise.

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Deepak7050

Could you pls share the screenshots of the flow for better understanding?

Thanks

Was this reply helpful? Yes No
Deepak7050 14 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your quick response. please see the below print screen

Was this reply helpful? Yes No
Deepak7050 14 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Deepak7050

In condition action, you just need one condition that compares variable with the conversation id of the received email. So after making the required changes, pls test the flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Deepak7050 14 on at

Like (0)

Report
Copy link

Link copied!

i have tried these options with just one condition. however, when i am testing manually it works fine, but for other emails it does not identify and adds ups new row. is that something issues with the email subject line change ?? though when testing i have changed the subject line and tried it works fine. for few emails it does not!
attached flow with one condition. kinldy provide me any examples or print screen of the flow which will work fine, identifying the conversation ID and updating the same row if found and if not found add a new row in the table

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Deepak7050

Pls check the conversation Id coming from the received email. I think the conversation Id changes every time other people replied to the original email thread. Pls check that too.

Thanks

Was this reply helpful? Yes No

Deepak7050

14 on at

Like (0)

Report

Copy link

Link copied!

No it does not change its the same Conversation ID. Please see below. can you advise if the flow is correct ? or suggest me different approach

Subject line	Conversation ID
FW: Test	AAQkAGI1ZjZiNGJkLTFkYTAtNDMyMC04NWExLTM4Njk4ZjIxY2I1ZQAQAGBrmgHuYkEhkas8FWzH5mU=
RE: Test	AAQkAGI1ZjZiNGJkLTFkYTAtNDMyMC04NWExLTM4Njk4ZjIxY2I1ZQAQAGBrmgHuYkEhkas8FWzH5mU=

Was this reply helpful? Yes No

Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Deepak7050

Pls share the details of columns in excel sheet or upload the sample excel file. I will give a try and share the flow which you can import in your environment.

Thanks

Was this reply helpful? Yes No
Deepak7050 14 on at

Like (0)

Report
Copy link

Link copied!

PFA

test.xlsx

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Deepak7050

Thanks for sharing the excel sheet. It looks like this excel has been used for multiple processes so I have taken only 2 columns (subject & Conversation Id) for a sample flow:

Here is the attached flow which will add a new row if conversation Id is not present in excel sheet. If found, we will update the row in excel sheet. 'Conversation Id' is being taken as row identified or key column in excel sheet.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

CheckAndSaveConve...

Was this reply helpful? Yes No