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 / Crosstab Query Alterna...
Power Apps
Unanswered

Crosstab Query Alternative for View

(0) ShareShare
ReportReport
Posted on by 3

Hello All,

I am so seriously frustrated as I have been developing the application for some time now and am now at a fork in the road where I either call it quits and move on to a different platform or somehow get this to work. 

 

Can someone (anyone!) tell me how to create an equivalent of a Microsoft Access crosstab query in a Model Driven App view?

I have your standard normalized database tables - Products, Accounts, Date and even created one that is called Time Periods which is just YYYY-QQ. 

 

What I am trying to accomplish?
I need to create a view that shows products on the left column with 'YYYY-QQ' on the column headers, with sales qty as the details. 


What I have tried:

I was able to use XRMTools (SQL to XML) and create the view in XML, but received a message that read something along the lines 'further processing is needed...' . The result set was correct, but I didn't know what to do next. Can I upload the XML view, if so how? (and even if I did would it work?)

 

Why the frustration?:

Microsoft Access has this functionality so I am hoping it is maybe just me and that the functionality is there (albeit less than intuitive than I would have thought).

 

If anyone with knowledge on how this can be accomplished and or an alternative,please let me know. 

 

Thanks!

 

 

I have the same question (0)
  • 365-Assist Profile Picture
    2,324 Moderator on at

    As a person who used to build MS Access apps I know your pain. Using Dataverse as it currently stands by itself doesn't have that functionality. There are 2 different ways I have gotten around this.

     

    1 - Using Power BI. It has a very good Crosstab feature. You can add your Power BI report as a Dashboard in your Model Driven App.

    365Assist_0-1679183532820.png

     

    2. Create a Custom Page and using ComboBoxes, Collections and Galleries you can build functionality that can provide a list of what you need.

     

    ---------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard