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

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,163)