@Alex_Security
So, this is relatively challenging in PowerApps (from a table perspective). The reason is that you are trying to dynamically change a record schema, and you can't do that in PowerApps. You're also trying to reference a column by its text name...this also cannot be done in PowerApps.
Now, that said...you can do many ways to get around it, but it takes some work.
Consider the following - a ListBox (I used a list box as it was easier to manipulate, combobox works fine too). with the names of the Columns you want to view in it. In your case: ["TechA", "TechB", "TechC"]
In a Gallery, the following Formula:
ForAll(
yourData,
{Feature: Feature,
Columns:
Concat(Sort(["TechA", "TechB", "TechC"], Value),
If(Value in Sort(ListBox1.SelectedItems, Value), Value & "|" &
Switch(Value,
"TechA", TechA,
"TechB", TechB,
"TechC", TechC
) & "~"
)
)
}
)
You can see the above it the manual part and painful if there are a lot of columns.
Now, in the Gallery, a Label with ThisItem.Feature for the Text property.
And a horizontal Gallery in the Vertical gallery with an Items property of:
Filter(Split(ThisItem.Columns, "~"), !IsBlank(Result))
In the Horizontal Gallery, a label with the text property of : Last(Split(ThisItem.Result, "|")).Result
To give it a header, another Gallery, outside of the main one and on top. Gallery Items property set to:
SortByColumns(ListBox1.SelectedItems, "Value")
And a Label in the Gallery with the Text property of : ThisItem.Value
Final result is this:
I hope I read what you were looking for properly and that this is helpful for you.
