cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DAsogan
Frequent Visitor

Email Flow based on Conversation

Hi All,

 

I've built a simple flow to fill in data in an online Excel spreadsheet when an email comes in to a shared email inbox.  What I would like to do is only add to the data table in Excel if the conversation is new, i.e. if the e-mail recieved is a reply then I would not like it to fill in data.

 

I would also like to fill in another column when the first e-mail in the conversation is responded to and yet another column when the conversation is marked complete, but that may be another topic.

 

Any ideas on which conditions I should use?

 

Thanks in advance all.

Dhinesh

3 REPLIES 3
v-bacao-msft
Community Support
Community Support

Hi @DAsogan,

 

In general, the Subject line of Reply mail will be prefixed with a "RE:" or "Re:".

Perhaps you could check whether the subject of the received message starts with "Re:"/"RE:", if not, it is the new conversation. Then configure the corresponding action in the If no branch.

Formula reference:

 

@or(startsWith(triggerBody()?['Subject'], 'Re:'), startsWith(triggerBody()?['Subject'], 'RE:'))

Image reference:

7.PNG

Unfortunately, there is no suitable way to monitor whether the first e-mail in the conversation has responded currently. Flow does not currently support such a feature.

As for monitoring whether the conversation is marked as completed, you could use When an email is flagged as the trigger for Flow.

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks Barry, that's a great suggestion!

 

I'll probably have to update it with regional language variations since I'm expecting e-mails from personnel that don't have English set on their local computer (e.g. German uses "AW:", etc.), but that is easy enough to add from the look of the formula.

 

Any idea where I could start with looking through the existing Subject column so the entry can be updated?

 

I'll have a play and post back if I find something.

 

Cheers,

Dhinesh

Hi @DAsogan,

 

You could use Get rows action to get all the rows, then put the value of the Subject column into an array variable and see if the array contains the specified value.

A similar Thread hopes to give you some hints:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Check-if-value-in-excel-exist/m-p/174915#M375...

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,427)