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 / Delete items from SP l...
Power Automate
Unanswered

Delete items from SP list filtering with a Yes/No Column

(0) ShareShare
ReportReport
Posted on by 2

Hello, I'm kind of new at Power Automante and I have a question:

 

I have a SP list with some contacts, and I want a flow to delete some of them.

If the contact has this column "Indexar" with a No,  it should be deleted. 

1.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In Power Automate shouldn't be simples as this bellow?

Or am I forgetting something?


2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Every time I test this flow it gives the

bellow error and it adds more repeated contacts:

 

3.png

 

 

 

 

Thank you in advance.

 

Edit: Text Alignment 

Categories:
I have the same question (0)
  • David_MA Profile Picture
    12,982 Super User 2025 Season 2 on at

    In your filter query, delete the word No and go into the Expression builder and type false and use that expression in the filter.

  • FilipeSV Profile Picture
    2 on at

    Hey, thank you for your answer, unfortunately I've already tried that and it didn't work, I've also tested Null

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @FilipeSV  Pls use 1 for Yes and 0 for No.

    Hardesh15_0-1675710201570.png

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

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 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard