Countrow of distinct item

(0) Share

Report

Posted on by punksterz626

Hello All,

How can i set up a count of employees that are distinct to the 'Job Title' and report to the reporting Manager?

So i want a gallery with a list of distinct titles and the number of employees for that specific title.

Example table below:

Admin 1

Manager 2
Sales Rep 2

I currently have a variable set as mgrVar= Thisitem.Employee that needs to be incorporated into the formula. It is a onselect variable. Not sure if this matter, but not all reporting will have the same type of job title employee. Some managers will have Specialist, supervisor, etc. That is the why I want it dynamically show whomever is selected their respective employee title and employee count will appear.

Employee	Job Title	Reporting Manager
Pluto	Admin	Bugs
Mickey	Manager	Bugs
Minnie	Manager	Bugs
Donald	Sales Rep	Bugs
Goofy	Sales Rep	Bugs

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@punksterz626

For your table above, as the Items property of a gallery:

GroupBy(Table,"Job Title","DATA")

Put two labels in the gallery, One with Text property ThisItem.'Job Title" and the other with CountRows(ThisItem.Data)

Using your data:

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@punksterz626

You could even show them with names by putting a listbox in the gallery with the Items property ThisItem.DATA.

Was this reply helpful? Yes No
punksterz626 on at

Like (0)

Report

its not accepting the groupby function.

So on the blank gallery Item property i have the following syntax Groupby('Org Chart', "Job Title", "Data")

Org Chart is the source (sharepoint List). Did i do something wrong here?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@punksterz626

GroupBy not Groupby

Was this reply helpful? Yes No
punksterz626 on at

Like (0)

Report

For some reason intellisense is not recognizing the 'Job Title' name

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@punksterz626

Is anything else showing up that looks close? Maybe you repurposed the Title column?

Was this reply helpful? Yes No
punksterz626 on at

Like (0)

Report

A datacard in the form. I found a workaround. It the form the Datafield listed it as "field_2" and it worked when i try using that.

Now, how do I combine these two syntax in the gallery? Right now its listing all the Job Title in the SP list and the total numbers. The filter is used when a certain employee is selected.

Filter('Org Chart',Employee =Gallery3_1.Selected.Employee)
GroupBy('Org Chart',"field_2", "Data")

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@punksterz626

That sounds like a different question.

Was this reply helpful? Yes No
punksterz626 on at

Like (0)

Report

it's not listing the manager's employee. it is listing the entire SP list and total. I need to incorporate this variable in the formula so that when an employee is selected only the result for the employee will populate

mgrVar= Thisitem.Employee

Was this reply helpful? Yes No