Skip to main content
Community site session details

Community site session details

Session Id : PkJ8hZ1kjT1UcjBlOYugyt
Power Automate - Building Flows
Answered

Item not found when an item is deleted

Like (0) ShareShare
ReportReport
Posted on 4 Jul 2019 07:04:07 by

I want to delete an item from a list. I need to store a value from the deleted item to use it for calculation in another list.

 

I use action "when an item is deleted", then the next step is "Get Item".

Capture11.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


However I get the following error message:

Capture12.PNG

 

 

 

 

 

 

 

Capture13.PNG

 

 

 

 

 

 

 

 

 

 

 

Regards,

Deddy.

  • Lionheart831 Profile Picture
    14 on 31 Jul 2023 at 12:50:59
    Re: Item not found when an item is deleted

    How can you send the email to the person that created the item that got deleted?

  • dee2005 Profile Picture
    93 on 21 May 2020 at 18:13:44
    Re: Item not found when an item is deleted

    @Anonymous  i've been struggling with this also but I managed to find a way to do this and keep things automated. You have probably solved your problem by now... but here is what I did:

     

    1. in my sharepoint list a created a calculated column to get any info from other columns that I would need if i deleted it and used a very distinctive separator which will come in handy later in flow, something like "*-%" & [field1] & "*-%" & [field2] & ... "*-%" & [fieldx].

    2. I set up the "alert me" option on the list for when an item is deleted.

    3. I set up a rule in Office 365 to move all emails from sharepoint with the name of my list in the subject (alert me includes the list name in the subject)

    4. I created a flow that gets triggered when an email arrives in this folder.

    5. in my flow i use html to text to get the body of the email and then i pass this to an array variable. 

    split(body('Html_to_text'),'*-%*')
    6. from the array variable I easily get all the fields ignoring [0] and the last item, variables('recoveryInfo')[1]
    finally i just perform the actions i need that need these deleted values 😀

  • Community Power Platform Member Profile Picture
    on 05 Jul 2019 at 01:29:13
    Re: Item not found when an item is deleted

    Hi @yashag2255,

     

    I have regretted stopping using SharePoint Designer, and starting using Flow 3 years ago. Flow was launched with many basic weaknesses. I am also having another problem with action "when an item is created or modified" where it causes flow run indefinitely. I have forgotten most of SharePoint Designer because I was also a beginner at that time and only using it for one year. Now I have to start learning it again.

     

    Anyway, thanks a alot for your help.

     

    Regards,

    Deddy.

  • Verified answer
    yashag2255 Profile Picture
    24,635 Super User 2024 Season 1 on 04 Jul 2019 at 10:32:00
    Re: Item not found when an item is deleted

    Hey @Anonymous 

     

    There is a limitation on this one. So when an item is deleted is triggered, you can just get the name, ID etc and not any of the columns associated with that item. So this way, it would not be possible to get the other list to update when an item is deleted from List A. 

     

    You might want to create workflow in SP itself to achieve this. Here is a post that shows how to do that:

    https://stackoverflow.com/questions/16295567/how-to-create-calculated-column-with-data-from-another-list/16308478

     

    Hope this Helps!

     

    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 04 Jul 2019 at 09:37:43
    Re: Item not found when an item is deleted

    Hi @yashag2255 ,

     

    It does make sense now. Thanks for the explanation.

     

    The scenario is that I have two lists, say List A and List B.

    List A has a column named Allotment, numeric type.

    List B has a column named AmountOfFieldLeave, numeric type.

     

    When an item is deleted from List A, the value in column AmountOfFieldLeave in List B must be deducted by the value of column Allotment of the deleted item.

     

    To make it more clear please find the following lists (the lists do not show the whole tables)

     

    Capture-1.PNG

     

     

     

     

    List A

     

    Capture-2.PNG

     

     

     

     

     

     

    List B

     

    List B is the summary of data in List A. When I delete the record "Deddy Andy        5" from List A, then the corresponding record in List B must change from "Deddy Andy       7" to "Deddy Andy       2".

     

    Appreciate for your help.

     

    Regards,

    Deddy

  • Verified answer
    yashag2255 Profile Picture
    24,635 Super User 2024 Season 1 on 04 Jul 2019 at 08:45:22
    Re: Item not found when an item is deleted

    Hi @Anonymous 

     

    So how this works is, the Get Item action is an independent action that will be executed. For the trigger: When an item is deleted, this is triggered when the item is deleted and the trigger itself brings some data as I have shown in the previous resposne. Similarly, for the When an item is created or modified, you get the Id from here and now the Get Item action runs and makes a new call to SP to get that particular item referenced here. So that way, on the When an item is deleted will not work as the item doe not exists when the get item is being executed. Makes sense?

     

    Can you share the scenario that you are trying to build so that I can have a better look and suggest a possible solution? 

     

    Hope this Helps!

     

    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 04 Jul 2019 at 07:46:51
    Re: Item not found when an item is deleted

    Hi @yashag2255,

     

    So I guess it is different from action "when an item is created or modified" where we can access all information in an item.

     

    Could you please tell me of how to solve my need?

     

    Regards,

    Deddy.

  • Verified answer
    yashag2255 Profile Picture
    24,635 Super User 2024 Season 1 on 04 Jul 2019 at 07:14:44
    Re: Item not found when an item is deleted

    Hi @Anonymous 

     

    The action Get Items only works for items that are present in the SP list when that action is executed so you cannot really get the item that way. jsklfdj.PNG

     

    Here i am sending the ID details and the title and the person who deleted the item in an email. 

     

    Hope this Helps!

     

    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!

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2