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

How to count number of times names appear in a sharepoint list

Hi all,

 

New to PowerApps and Microsoft Flow so any help here could be appreciated.

 

I have List A which contains all sales including Employee Name and Income per sale. I want to create a "leaderboard" of sorts using this information via Flow that goes to List B and displays each salesperson's (we only have 25, so I can enter them manually) total units sold (only one unit is ever sold at one time) and total Income. I have attached a screenshot of my current attempt, but the expression

"length(body('Get_items')?['value'])"

seems to only count one time and fails to iterate. Any help would be greatly appreciated!

 

 

2 REPLIES 2
Dawidvh
Level 10

Re: How to count number of times names appear in a sharepoint list

Hi @e_jones

 

Sounds interesting.

 

How many list items in these lists?

 

Are you planning to display the leaderboard in PowerApps or Power BI?

 

If you use PowerApps, you might not need the Flow run to collate the data.

 

Kind regards

 

twitter: @dawidvh

youTube: https://www.youtube.com/channel/UCIMe_ErQZP5chbI9UyW0xLw

>>If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.<<

e_jones
Level: Powered On

Re: How to count number of times names appear in a sharepoint list

Hi there,

 

I plan on making one list per calendar year, so at the end of the year List A might have ~1500 items. List B (the leaderboard) will only show employees' names, and we have around 25 employees that should show on the leaderboard. Ideally I'd have the leaderboard show as a sharepoint list and just customize views for each month (i.e. January shows data for January, etc.). This might not be possible, though. Here's a picture of what the ideal output would be in List B:

sc3.jpg

 

 

I think right now I'm just having trouble filtering the query, as with every Flow run the "Policies Written" value does not increment.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 44 members 4,598 guests
Please welcome our newest community members: