cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Using unique field's values as columns in a subgrid

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: 

 

BrandJanFebMarApr
Toyota5678
Honda3456
BMW2654
Opel1457

 

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.

 

IdBrandNo of carsPeriodPlan
1Toyota2JanPlan A
2Honda3FebPlan 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: 

 

BrandJanFebMarApr
Toyota2---

 

Is it possible? 

1 REPLY 1
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (70,789)