cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MaxWendorff
Level: Powered On

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
Super User

Re: Remove Record If Quantity is 0!!!!

@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
Super User

Re: Remove Record If Quantity is 0!!!!

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
Super User

Re: Remove Record If Quantity is 0!!!!

@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
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,417)