Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Help with Sharepoit List

Hi all!

I'm stuck here with this Sharepoint List columns formula.
Probably there is a easier way of doing this.
I have a column with two choices, one for phone and other for laptop.

I created the columns but it substract same value 1-10=9.
I would like when select phone it substract -1 from the value of the Available phones column ex.10.And so on everytime is added a new row until it reach zero available.
And when delete the rows it comes back to the default value ex.10.
The same for the laptop choice of course.
I'm gratefull for some advice!

2020-08-21 10_58_25-Window.png

Dual Super User
Dual Super User

Can you show us the actual formulas you are using?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.



Hi! Thanks for replying!

I am trying to do it in another way.

I'll come back to you if I need your help.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,926)