cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kelligan
Helper I
Helper I

How can I customize a screen to have a matrix style layout (Similar to the Cross-Tab Query from MS Access)

Hi Folks,

Just arrived in the forums and am a brand new Power Apps User. I have been looking through the LinkedIn Learning courses and visiting YouTube for help but I am not sure I know how to even ask this question so I am coming here for help. 

 

Our customer has us rebuilding site assets in SharePoint Online and Power Apps that are due to migration from on-prem and InfoPath. They want as little difference in the look as possible. One of the screens is laid out in a matrix style data sheet that is similar to what you would see in a cross tab query or an excel pivot table. I did get a layout up by dropping a gallery on the screen and that gave me lots of design flexibility but that will also show multiple records. Can I either use a different control (rather than a gallery) to accomplish this or limit the gallery to displaying one record? I plan to get to this matrix screen from another gallery used in the traditional way. Here are some screenshots of what I have done already. 

 

Martix01.jpgMartix02.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks and Regards,

Patrick

1 ACCEPTED SOLUTION

Accepted Solutions
JacobShand
Helper II
Helper II

Hi mate,

 

I'd definitely recommend using a gallery. What you can do is set the items for the gallery to FullGallery.Selected

This will give you the data from the gallery item you selected from the screen before. 

 

Hope this makes sense! 

 

Regards,

Jacob Shand | Automation Specialist

NextStep Creations


Taking your PowerApps Skill the NextStep

View solution in original post

3 REPLIES 3
JacobShand
Helper II
Helper II

Hi mate,

 

I'd definitely recommend using a gallery. What you can do is set the items for the gallery to FullGallery.Selected

This will give you the data from the gallery item you selected from the screen before. 

 

Hope this makes sense! 

 

Regards,

Jacob Shand | Automation Specialist

NextStep Creations


Taking your PowerApps Skill the NextStep

View solution in original post

Thanks @JacobShand! That did the trick. Thanks for giving this noob a hand!

 

Best Regards,

Patrick

Anonymous
Not applicable

hi Kelligan !!!

Could you help me explaining how you did it?, i need to create something similar to your screenshots. 
thank you!! 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,463)