Unanswered

Creating a dynamic condition and response.

(0) Share

Report

Posted on by Mark-E

Is there a way to create a document that contains possible Subject lines of e-mails that we will get? That same document would contain the response that we would like to reply with. Then have flow check the document when the e-mail comes in then auto reply with the corresponding response from the document?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Brad_Groux 4,556 on at

Like (0)

Report
Copy link

Link copied!

You wouldn't use a document for this, but instead a SharePoint list. So your columns for your list could have a Subject column, with all of the possible subjects, and a Response column for the canned response you'd send for that subject. Utilizing parallel conditional branches, you would send the Response emails that match the received email's Subject. The Flow would look something like this (just add branches for each response you need):
You could also nest the conditions, it is kind of up to you. I like doing parallel branches at the highest possible level though, to improve the overall performance of my Flows.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS

Was this reply helpful? Yes No
Mark-E 2 on at

Like (0)

Report
Copy link

Link copied!

So if I had 24 possible subjects, I would need 24 different conditions? If so what whould be the use of doing it this way vs just having a seperate flows for each subject line? I'm just thinking toward the future where we will be adding and removing subject lines and responses.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@Mark-E

The Sharepoint approach from @Brad_Groux is a good advise. But taking into account you have such a big number of options... instead of a condition block, I would suggest you to add a Filter Array action block after "Get items". This Filter will provide you all items from Sharepoint list matching Subject in the incoming email (unless you add the same subject twice in the Sharepoint list, you will get 1 or 0 results).

Next I would add a Condition, and use the following expression:

@equals(length(body('Filter_array'),1)

On the "True" branch I would apply a service logic dependant on the matching item, on the "False" branch I would add a Terminate action block.

Hope this helps!

Was this reply helpful? Yes No