Power Platform Community Forum Thread Details

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!

Categories:

Microsoft Dataverse with Power Apps

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.

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