Unanswered

Send a customized email when a new file is added

(0) Share

Report

Posted on by marquesj7

Hi!

We're currently using Sharepoint as a "general" inbox instead of a shared Outlook folder. I need Power Automate to send an email to notify the correct user whenever a new item/email is created on sharepoint, based on the name of the file/email subject.

Example: whenever a file is added with "12345" on its name, the user 12345@company.com will be notified via email that this file was added.

Thank you for your help 🙂

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @marquesj7 ,

please follow these steps:

1. When a file is created in a folder, Get file metadata; please set the "x-ms-file-id" in the "File Identifier" field:

2. Add the "Get file properties" action, please set the "ItemId" value grabbed from the previous action:

3. Add the "Send an email (V2)" action, in the "To" field set the "Name" value, grabbed from the previous action, followed by @ and the company domain.

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
marquesj7 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Marco,

Thank you very much for the quick reply. On step 2 I'm unable to select "x-ms-file-id" and if I write it, it shows an error while testing.

Either way, I'm not sure if this will work as the file name as words other than the ones I'm looking for, and the word I need to look for doesn't match the company's email. This was something I didn't explained in OT. On the text I'm looking for, user 12345 has 2 letters also, like JM12345 so it doesn't match company's email

I don't mind creating a flow for each user

Thank you again!

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @marquesj7 ,

regarding the 2nd step, please search for "id", otherwise if you're not able to get it, add before a "Compose" action and search for "id".

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
marquesj7 6 on at

Like (0)

Report
Copy link

Link copied!

Hello @MarconettiMarco

Turns out I found an "easier" way to notify people when an email arrives. Please check the screenshot attached.

The problem is that on the "Condition" / Name, I have at least 50 different people. Do I need to create a Condition for each user?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Just create the JSON array where each record contains 2 values: name and address.

Was this reply helpful? Yes No
marquesj7 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @VictorIvanidze ,
Can you please elaborate? I'm kinda new to this, sorry!

Thank you for your help!

Was this reply helpful? Yes No