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

Count Numbers in Column Sharepoint

Hi, 

 

I want to make a inventory gallery. So i have one list with items that i want to sum/count, but the code that i use gives an transport warning. Anyone a idea how to fix this? 

 

The code that i use: 

 

 

Sum(Filter(Uitgeleend;ThisItem.Titel="Titel");"AantalUIT")

 

 

 

My SpList: 

problem 7.png

So i want to filter on titel (and count/sum the red column and display the answer in the a record galllery label on my app.

 

problem 6.png

If there are other ways that are easier, please let me know.

Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

Insert a Textbox1 and in the Default:

Sum(Filter(Gallery1_1.AllItems,Title="AT Pro"),AantalUIT)

 

Or

Sum(Filter(Uitgeleend; Titel = Gallery1.Selected.Title);AantalUIT)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

4 REPLIES 4
eka24
Super User
Super User

Insert a Textbox1 and in the Default:

Sum(Filter(Gallery1_1.AllItems,Title="AT Pro"),AantalUIT)

 

Or

Sum(Filter(Uitgeleend; Titel = Gallery1.Selected.Title);AantalUIT)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

Thanks! It works 🙂 

Which of them did you prefer

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

I did this: 

 

Sum(Filter(Uitgeleend; Titel = ThisItem.Titel);AantalUIT) 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,228)