web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How can I customize a ...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 49

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

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    49 on at

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

     

    Best Regards,

    Patrick

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    hi Kelligan !!!

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard