Unanswered

Group By Function - for sharepoint records

(0) Share

Report

Posted on by YOG

i have created 'interview Tool' application (mobile) just like interview tool template provided in Power apps home page.

My app is connected with SharePoint list.

i got a gallery1 with 'position title' data selected on home page. All rest form fields has been set as ' gallery1.Selected.Title'

case table is as below -

Title Position Title

A X

A Y

A Z

as per above table, this adds 'Three different entries on 'Gallery1' on home page. I mean gallery shows value 'A' three times.

if i use 'Groupby' formula, it groups to 1 name so i can see only one value 'A' on home screen. But as because other fields has been set as per 'gallery1.selected', group by section doesnt work!

i hope this make sense.

can you please advise alternatives!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Abdou Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I don't think I understand your question entirely, but if you're trying to display the grouped items, you would need to add another gallery inside the first one and set its source to the group name you used in the GroupBy function.

Hope this helps 🙂

Was this reply helpful? Yes No

YOG

12 on at

Like (0)

Report

Copy link

Link copied!

Thanks mate for your reply.

Let me make my question bit clear.

i have got a application designed for SharePoint list as below -

Department	Position Title	Hiring Manager	Job Description	Candidate Name	Email Address	Phone Number	Additional Feedback	Positions	Review Candidate
Marketing	GD2	LD1	Designing	AB1	@gmail.com	5,768,699,303,556	Well done	Closed Positions	Hired
Marketing	Graphics designer	LD	Required	Yp	@yahoo.com	84,844	Very good employee	Closed Positions	Hired

i got a different screen set up in power apps & home page has gallery filtered by 'Department' column,

i have got two 'marketing' name in department column so data in gallery function is giving me two samilar name field this is where i need help. i want to group 'Department' column.

i did group department column which works fine as it is giving me unique name. just one name 'Marketing' in above table.

i have set up form fields to 'HomePageGallert.Selected.Department' So Group function doesnt work.

How can i solve this problem.

Was this reply helpful? Yes No

YOG 12 on at

Like (0)

Report
Copy link

Link copied!

More Specification....

how to use 'GroupBy' function for SharePoint Data.

Was this reply helpful? Yes No
Abdou Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I still don't quite understand the issue. Can you please post some screenshots showing the problem?

Was this reply helpful? Yes No
YOG 12 on at

Like (0)

Report
Copy link

Link copied!

hello mate, here are some pictures,

as you can see i have got app links to the sharepoint library.

Home screen of the app has 'Gallery2' set up.

if i use 'group by' function on home screen, it doesnt work as form doesn't support groupby function.
i am not able to set 'form field' property.
i hope this make sense.
thanks for your help

Was this reply helpful? Yes No
Abdou Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
The Form control doesn't support GroupBy because it only shows one item. Also, when using the Form control, you should set its Item property to the Gallery.Selected.

If you want to show the list of positions grouped by department, then drill into each one you need 3 screens:
the first screen shows the list of departments
the second screen shows the list of positions for that department
the third screen shows an individual position
Let me know if this is what you're trying to accoumplish and I'll help you with that 🙂

Was this reply helpful? Yes No
YOG 12 on at

Like (0)

Report
Copy link

Link copied!

Hello mate,

please see link as below. this is an application previewed by Microsoft & i m trying to accomplish excatly the same.

https://web.powerapps.com/webplayer/app?source=portal&screenColor=rgba(126%2c+115%2c+95%2c+1)&apptype=sample&appId=%2fproviders%2fMicrosoft.PowerApps%2fapps%2f2c142864-d795-4c18-89e1-19519a989901

Please advise.

Was this reply helpful? Yes No
YOG 12 on at

Like (0)

Report
Copy link

Link copied!

i would appreciate your help on this.
please advise any alternatives

Was this reply helpful? Yes No
Abdou Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Sorry about the late reply.

The way you can accomplish that flow is by doing the following:
In the "Departments" screen, have a Gallery that lists the list of Departments.
In the Positions screen, you can set the Items property of the gallery to something like:
Filter(Positions, DepartmentId=Departments.Selected.Id)
Similarly, in the Candidates screen, you can set the items to something like:
Filter(Candidates, PositionId=Positions.Selected.Id)
This way, you won't need to use group by.

Hope this helps.

Was this reply helpful? Yes No
CW 1,044 on at

Like (0)

Report
Copy link

Link copied!

Regarding the example: https://web.powerapps.com/webplayer/app?source=portal&screenColor=rgba(126%2c+115%2c+95%2c+1)&apptype=sample&appId=%2fproviders%2fMicrosoft.PowerApps%2fapps%2f2c142864-d795-4c18-89e1-19519a989901

So how do you download to open and learn???????????????????????? Why does everything with Microsoft have to be so complicated and unfulfilling???? Why cant you just download and open the #%^&5466 thing? Is it becausde it's not a Tuesday with a full moon? You get part way there (seeing the example) try to open and learen hoe it was done and: "sorry kids, you cant do that?" Why...............................um we dont know, that's just the way it is.

Was this reply helpful? Yes No