Simple flow to send email does not work

(0) Share

Report

Posted on by DevOs

118

Hello,

I am trying to build a flow that when an email is received in an inbox folder called "From Website" with the subject "This is from the website", then the email body is parsed and a table in dataverse is filled in with the parsed information.

But I can't get it to work. During testing, I will send a test email, it will go in the "From Website" folder with the subject line "This if from the website", but the flow will not run at all.

So I thought maybe something was wrong with my literal first step(the trigger) and created a basic flow that "If an email is received in this folder with this subject line, send a copy of that email to some other email". Simple. Literally 2 step flow. However upon testing again, this does not work as well!

I'm at my wits end. Someone have an idea what's going on here? I can't even get into the nitty gritty of my flow and parsing data properly.

Edit: Okay, the basic 2 step email flow works now. But if I try and get it to trigger off of folder in my inbox, it doesn't work:

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (2)

wskinnermctc 6,519 Moderator on at

Like (1)

Report

Do you really have the To set with testing@testing.com in the trigger?

During testing that should contain your email address as well as the From:

Since in testing you are sending the email to yourself from yourself.

I don't know if you just have that for the screenshot or something.

Was this reply helpful? Yes No
DevOs 118 on at

Like (1)

Report

No. I'm using private emails and just edited them for the purpose of posting on here. The logic is the same.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (1)

Report

How is the original email being put into the "From Website" folder?

If the email is moved into the "From Website" folder then it would not trigger the flow. You should test this using your Inbox folder.

Was this reply helpful? Yes No
DevOs 118 on at

Like (0)

Report

The setup I have is:

Inbox
>Sub folder called "New Lead From Website"

I *do* have a rule that new emails that come in with the subject like "New Lead From Website" are moved into the subfolder "New Leads From Website" and the flow is supposed to run off of new emails arriving in the subfolder "New Lead From Website" with the subject line "New Lead From Website".

But by your statement, flows cannot run off of emails in subfolders? Only main inboxes?

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (1)

Report

From what I have read it is a little confusing since it is hard to tell what is happening when you set up a rule, or where you set up the rule.
But it seems like your rule in the system acts more like a copy a file of the email into the "New Lead From Website" folder from the Inbox. So the trigger doesn't run because it's not a new email, it's a new file.

That doesn't seem right because why would PA give you the folder options?

But either way, you should test it off of your Inbox and see if that works. If it does then we know the problem has more to do with the rule or how the email is getting into the other folder.
If it doesn't trigger in the main Inbox, then it would be more about the settings or properties the Trigger uses to identify what email to trigger on like "Subject Filter" or "Includes Attachments Y/N" fields.

Was this reply helpful? Yes No
DevOs 118 on at

Like (0)

Report

So I tested this and set it to a different subfolder and it worked to trigger the flow. My assumption being that something is wrong with the rule I have for "New Lead From Website", but it's the exact same rule as the other sub folder in my inbox.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (2)

Report

Well at least that is narrowed down.

I saw something that said there was a difference between where the rules were made (which I don't understand). The difference between desktop Outlook and online I guess?

Maybe see if that has anything to do with it??

Or if the option "On this computer only" is checked?

Was this reply helpful? Yes No
DevOs 118 on at

Like (0)

Report

I figured it out. Turns out you were indeed correct and I had some conflicting rules in Outlook. Lots of them were based off of sender rather than subject. So there were other rules running based off of the website automailer.

Now I'm actually into the meat and potatoes of the flow and having issues with parsing the email body for the following elements in the email:
//
First Name:
Last Name:
City:
Province:
Phone Number:
Email Address:
Message:
//

I've created 7 compose steps and am using expressions such as this for "First Name:"
//first(split(outputs_shared_conversionservice_HtmlToText?['body'],'First Name: '))//

But clearly I'm doing something wrong as it's literally just giving me the expression itself. I also tried:

//replace(first(split(last(split(body(‘Html_to_text’),‘Phone Number:’)),‘Email Address’)),‘\D’,‘’)//

But PowerAutomate said that was an invalid expression flat out.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report
I'm not sure you are putting the expression in correctly. You have to add it over in the dynamic content box and add it in the field. You can't just type the expression into the field.

Here is a quick example email I made:

Example Email Body

My email message body looks like this:
Here is a bunch of website data from somewhere in outer space. First Name: Steve Last Name: Harvey City: New York Province: Canada Message: Hey welcome to family feud!

Here is the expression to get the First Name:
trim(first(split(last(split(outputs('Html_to_text')?['body'],'First Name:')),'Last Name:')))
Here is the expression to get the Last Name:
trim(first(split(last(split(outputs('Html_to_text')?['body'],'Last Name:')),'City:')))

Here is a screenshot of the flow:
Flow Example - First Name and Last Name

This is the expression to get the City:
trim(first(split(last(split(outputs('Html_to_text')?['body'],'City:')),'Province:')))
This is the expression to get the Province:
trim(first(split(last(split(outputs('Html_to_text')?['body'],'Province:')),'Message:')))
This is the expression to get the last row Message:
trim(last(split(outputs('Html_to_text')?['body'],'Message:')))

Here is a screenshot of the flow and where the expression is added or updated:
Flow Example 2 - Expression

Can you use this as an example and get the values you need?

Was this reply helpful? Yes No
DevOs 118 on at

Like (1)

Report

Can you please explain why you're using initialize variable instead of compose? Is it because it will store it as data and then it can be referenced in the "add a new row" step? Does compose not do that?

Edit: All good! I figured it out and after some wrangling and banging my head into a wall with other problems on the website, I got it all sorted out. Everything works and works as desired! Thank you so much for your support wskinnermctc ! You're awesome!

Was this reply helpful? Yes No