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

[Kelligan]

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. 

Thanks and Regards,

Patrick

[JacobShand · Accepted solution]

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

[Kelligan]

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

Best Regards,

Patrick

[Anonymous]

hi Kelligan !!!

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