web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send mail if Sharepoin...
Power Automate
Unanswered

Send mail if Sharepoint list item is delted

(0) ShareShare
ReportReport
Posted on by

Hey.

 

i'm trying to built an easy flow, which sends an e-mail out, if an item from a sharepoint list is deleted. The e-mail should be send to the creator of the deleted list item.

 

2019-05-17 13_46_47-Run History _ Microsoft Flow.png

 

My current flow fails with a 404 Error "Item Not Found" at the GetItem action. I'm guessing i try to get values of an already deleted item. 

 

Is there any other way to accomplish this task?

 

Greetings

Categories:
I have the same question (0)
  • Brad_Groux Profile Picture
    4,556 on at

    Because the When an item/file is deleted are triggers, you are limited on what you can capture from them. Currently, When an item is deleted triggers it only captures six parameters for use

    When an item is deleted it it offers six parameters to use within the Send an email (V2) action (see the subject and body areas):

    WhenItemIsDeletedSendEmail.PNG

    When a file is deleted it offers six parameters to use within the Send an email (V2) action (see the subject and body areas):

    WhenFileIsDeletedSendEmail.PNG

    If you'd like expanded built-in functionlity added to Flow, please consider submitting it to the Flow Ideas page, where it can be voted on by other users, and tracked and commented on by the Flow team.

    You do have some alternatives, however. The connector does have a DeletedItemList Parameter available to it. So, you can invoke it as an Object Variable for usage within your Flow (such as passing it through to the email).

    VariableDeletedItemList.PNG

    You'd have to do some testing to see what the DeletedItemList variable returns. If it does return the item creator, then you could grab that and also pipe it into the Send an email. 

    For more information on how to utilize variables, review the Create variables for saving and managing values in Azure Logic Apps documentation

    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!

  • Community Power Platform Member Profile Picture
    on at

    hey @Brad_Groux ,

     

    thanks for your reply!

    If i did everything correctly, these should be the values of that variable:

     

    {"ID":12,"Name":"Test","FileNameWithExtension":"Test","DeletedByUserName":"My Tesuser name","TimeDeleted":"2019-05-18T09:06:22Z","IsFolder":false}

    Is there a function to get the user e-mail by username? Could be buggy though, if there a two employees with the exact same name.

     

    Greetings!

  • v-bacao-msft Profile Picture
    on at

    Hi @Anonymous ,

     

    Basically, if this item has been deleted, then we can't get information about the item's Creator because the item doesn't exist anymore.

     

    Perhaps you could consider using the following methods to achieve your requirements.

    • We need to create an additional list to store the information in the original list, similar to a lookup list.
    • This list needs to add two fields, one is used to store ItemID in the original list, and the field type is Number.
    • Another field is used to store the email of Creator contained in the item.
    • In addition to creating an additional list, we need to configure an additional Flow to add the items from the original list to the lookup list.

     

    Lookup list:

    17.PNG

    Additional Flow:

    15.PNG

    Flow used to send email:

    16.PNG

     

    Hope it helps.

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard