Pivot Table Like (Help!)

[Romansx]

Hello, I am trying to summarize my collection that is conformed more or less like this:

Art	Talle	Qtity
1	40	1
3	41	5
4	39	3
1	40	2
1	39	3
2	38	2
3	41	1

I need some formula to summarize the data in another table like this:

Art	38	39	40	41
1		3	3
2	2
3				6
4		3

I think pivottable excels like should be the best alternative, but i dont find any control that approach at this behavior...

Any ideas on how i can achieve this???

Tank you

[v-monli-msft]

Hi @Romansx,

I'm afraid that Pivot table is not available in PowerApps so far. Also it seems that there aren't other ways I could think of to achieve this. But if you really need this, please consider to post this idea in the PowerApps Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Mona Li

[AnthonyPhan]

I have achieve a similar functionality but using nested galleries with formular driven lebels with the galleries.

[PaulD1]

Do you have power bi available? I haven't tried it, but maybe you could use a power bi matrix visualization and use the power bi control in power apps to display it.

[NigelP]

Hi

Could you share this ?

Thanks

NIgel

[agneum]

Create a stored procedure in something like SQL, which does a pivot and a select on the table. Run a flow calling that stored procedure. Keepin mind you would have to specify the columns you expect back in your JSON.