Remove Record If Quantity is 0!!!!

[MaxWendorff]

Hello, 

I am building an inventory application with power apps and a share point list. I need to have a record remove itself once its quantity hits 0. My share point table has 3 columns. Location, Part Number and Quantity. The share point list I am using is called "Zone 2"

I am a little confused and any help would be much appreciated!!

Thanks!

[timl]

Hi @MaxWendorff 

I think what you're looking for is this:

RemoveIf(Zone2, QTY=0)

However, please try this with caution, just in case I've misunderstood you and you end up removing more records than you intend!

[mdevaney · Accepted solution]

@MaxWendorff 

You have the right idea but the code should look like this instead.  Your syntax was more similar to UPDATEIF than REMOVEIF.

RemoveIf(
    Zone2,
    Zone2Table.Selected, Qty=0
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."