Answered

Remove Record If Quantity is 0!!!!

(0) Share

Report

Posted on by 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"

Quantity Captute.PNG

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

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

timl 36,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@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."

Was this reply helpful? Yes No