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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Delete Sharepoint List...
Power Automate
Unanswered

Delete Sharepoint List Item if Elsewhere

(0) ShareShare
ReportReport
Posted on by 45

I've a list that has 2 entries I'm trying to use.

Created By Email & Period Covering.

This "flow" triggers on When an Item is Created from List A, to which I'm trying to check if List B has an item with both Created By Email (ed@gmail.com) & Period Covering (11-2019) being equal to the new List A's entry - then, provided it is, delete the already existing item on List B.

Not sure how to achieve this.. written wise, I've got so far:

 

When an Item is Created (List A)

Get Attachments (List A)

(Some middle stuff to export it to excel)

Get Items (List B)

Get Attachments (List B) [I don't know if this or Items is required..]

Apply to Each [Forced..]

Condition:

CreatedbyEmail = Email

AND

PeriodCovering = Period Covering

Delete Item (List B)

 

For now, it just ignores my checks, presumably because I did it wrong.. any help would be greatly appreciated.

Categories:
  • ScottShearer Profile Picture
    25,331 Most Valuable Professional on at

    @EddyGee 

    You could accomplish your goal by using a Get Items action and looping through each item and use a condition. However, a much better solution is to use a Get Items action with an OData filter - that will eliminate the need for a condition and make your Flow faster.  If any records are returned, then it exists.  You can check to see if any items have been returned by using the length expression.

    Here is a link to a blog post that explains using OData filters in Get Items actions.

    Can you post a screen shot of what you have so far with as much detail as possible?

  • v-litu-msft Profile Picture
    Microsoft Employee on at

    Hi @EddyGee,

     

    I think this step Get Attachments (List B) is not required.

     

    Could you please share the action that PeriodCovering = Period Covering?

     

    What's the entity to apply to each? List A or List B? If you want to get you want, it should be List B.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 423

#2
11manish Profile Picture

11manish 308 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 177

Last 30 days Overall leaderboard