
Announcements
Hello All,
I am having issues with a data set that I have. The Work Order is a unique identifier which is attached to the same equipment A.
I want to make a section in powerapps that shows the equipment Code as a title, and all the associated work orders with their descriptions.
| Equipment Code | Work Order | Work Order Description |
| A | UniqueWorkOrder Number1 | Unique Description1 |
| A | UniqueWorkOrder Number1 | Unique Description2 |
| B | UniqueWorkOrder Number1 | Unique Description 3 |
| B | UniqueWorkOrder Number1 | Unique Description 4 |
This is how the visual currently looks:
A UniqueWorkOrder 1 UniqueWorkOrderDescription1 |
A UniqueWorkOrder 2 UniqueWorkOrderDescription2 |
To show the above, I am using text labels with the following functions inside.
ThisItem.EquipmentCode
ThisItem.WorkOrder
ThisItem.WorkOrderDescription
I would like the app to show:
A UniqueWorkOrder1 UniqueWorkOrderDescription1 UniqueWorkOrder2 UniqueWorkOrderDescription2 UniqueWorkOrder(Nth Number) UniqueWorkOrderDescription(Nth number) |
B UniqueWorkOrder1 UniqueWorkOrderDescription1 UniqueWorkOrder2 UniqueWorkOrderDescription2 UniqueWorkOrder(Nth Number) UniqueWorkOrderDescription(Nth number) |
I would appreciate the help, please. The data source is from PowerBI Direct Query.
Hi There
Group your source by, GroupBy(YourSource,"EquipmentCode","Headers")
Add two galleries
First gallery add a label and set the text to ThisItem.EquipmentCode
Second Gallery, add this as a sub-gallery inside the first gallery and set the Items to This Item.Headers
Add two labels to the second gallery and name them ThisItem.WorkOrder & ThisItem.WorkOrderDescription
There you go