I'm working on powerApps to display the data from sharepoint as below:
First I have table which have looku valus inside it.
in power apps I'm trying to display valus inside galary from this table (highlighted fields are lookup)
I used this formula but not work for lookup:
AddColumns(GroupBy('Activities', "Employee", "ByEmp"),"SumofPoints",Sum(ByEmp, 'Working hours'))
GroupBy only works with Tex,Numeric or DateTime fields
Employee looks to be a people picker field
Create another text field - name it employee text - and store the name as a string there (so you can use it for groupby)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
Community Support Team _ Lin Tu
Hi @RezaDorrani ,
Does GroupBy work in forms in Poweapps? I want to filter the choice column based on another choice column and I am wondering if it's possible with Group By ?
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!