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

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.

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (6,028)