Answered

how to create a flow that sends an email for a specific new item.

(0) Share

Report

Posted on by alleewiley

I have a list with two distinct content types. (cover 1 and cover 2) When somebody creates a new item choosing cover 1 i want the flow to send an email to a user 1 and when a new item is created choosing cover 2, i want a flow to send and email to a second email address, user 2.

currently the way i have my flow set up, not matter which content type is chosen, all items are sent.

I cannot figure out how:

new item (cover 1) sends email to user1 email address

new item (cover 2) sends email to user 2 email address

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (1)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
Hi @alleewiley

In the trigger, you can filter for the results that you want. For example, only results for Cover 1 or Cover 2. To do that you can do a OData query like:

<Name of the sharepoint column> eq 'Cover 1'

Do you have 2 flows or just one?

Can you share the Flow so that I can try to figure out what's going on?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
alleewiley 21 on at

Like (0)

Report
Copy link

Link copied!

Hello Manuel,
Thank you for the reply. Here is what my flow looks like:

Where would the trigger go and how would i add it?

Was this reply helpful? Yes No
Verified answer

manuelstgomes 6,625 on at

Like (1)

Report
Copy link

Link copied!

Hi @alleewiley

Now looking at your Flow, I have a more straightforward solution. Here's the skeleton of the whole process. You're using in your Flow "Get my profile," but I think you want to get the profile and the corresponding email of the person to send in case it's cover 1 or 2.

Using a Switch enables you to add more actions in case of more covers.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
alleewiley 21 on at

Like (0)

Report
Copy link

Link copied!

Hello Manuel,

Thank you for that solution. I have created the first flow and it looks like it has worked!
I have one final question:
When users attach a file to the form, how do i have that file attach to the email sent?

Thanks again!

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @alleewiley

Awesome! Glad it works!

To do that just expand the advanced options:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
alleewiley 21 on at

Like (0)

Report
Copy link

Link copied!

Hello Manuel,

I see that section but i am not sure what info goes into that area.

The attachments that i am trying to send through the email is the general "attach file" button in the form:

I don't see any dynamic content that relates to the "attach file" button

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @alleewiley

You can validate if there's an attachment using the property "Has Attachments". If there are you need to do an additional step using the "Get attachments" action, where you get all the attachments for that list item. Then you can add them to your email.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
alleewiley 21 on at

Like (0)

Report
Copy link

Link copied!

The problem now is that when i added the ID into the "get attachments" action, the email that is sent has an attachment but the attachments are all damaged when sent regardless of what kind of file it is. Also, it sends each attachment as a separate email instead of sending them all in the same email.

Was this reply helpful? Yes No
manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!
Hi @alleewiley

No, you need to fetch the attachments before so that you can insert them in the "Send email" action. In the ID, don't include the "Has Attachments," but the ID of the item that you're trying to find the attachments (in this case the trigger).

So it should be:

Trigger

If

Get user profile

Get attachments

send an email (with the attachments that you get from the previous step)

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
alleewiley 21 on at

Like (0)

Report
Copy link

Link copied!

Thank you for putting up with my issue, Manuel.

Unfortunately i am still not understanding the problem.
🙁

Was this reply helpful? Yes No