Using unique field's values as columns in a subgrid

[Termigez]

Hello everyone,

I have an entity Plan, Volume, Period and Brand. Inside the Plan entity I want to create a form with a subgrid that shows all the brands related to this plan as a rows, as a columns I would like to have a unique names of my Periods and as a values I would like to have the volume for each model in each period. Something like this: 

Brand	Jan	Feb	Mar	Apr
Toyota	5	6	7	8
Honda	3	4	5	6
BMW	2	6	5	4
Opel	1	4	5	7

To give you better insight of my model, in the volume entity for each new record you provide the number of cars, brand, period and plan.

Id	Brand	No of cars	Period	Plan
1	Toyota	2	Jan	Plan A
2	Honda	3	Feb	Plan B

Then in the Plan entity in the main form I want to create a subgrid that as a result would show only those record related to chosen plan, however in the view I show you above. So for Plan A it would look like this: 

Brand	Jan	Feb	Mar	Apr
Toyota	2	-	-	-

Is it possible? 

[v-xida-msft]

Hi @Termigez ,

Do you want to design a Subgrid within Main Form of your Plan Entity based on the your Volume, Period and Brand Entities?

If you want to design a Subgrid within Main Form of your Plan Entity based on the your Volume, Period and Brand Entities, I afraid that there is no way to achieve your needs in PowerApps currently.

The Subgrid control in Entity form could only be bind to single one Entity through "One-to-Many" relationship, it could not be bind to a combination of multiple Entities.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

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

Best regards,