cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Remove Record If Quantity is 0!!!!

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@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." 

View solution in original post

2 REPLIES 2
Super User III
Super User III

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!

 

Super User III
Super User III

@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." 

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (70,443)