To start with let me give a little backstory about the data I'm working with. The data I'm using has over 100 columns in it, I already created an editable table in powerapps that can handle this data, the issue comes in when an end user wants to add a column or delete a column from the source data. My solution in mind is to capitalize on Horizontal Galleries and transposed data to generate the records accordingly. If this works it would also be a lot better as far as resource usage goes and keep the app working quickly. So the Issue at hand is that I can have a Gallery based on the original data to bring up all available records, but I need to then filter the Horizontal column to display the transposed data accordinly. The idea of using transposed data and a horizontal gallery is as you know each generated item in a gallery is a new record, so if all of one item is stored in one column then each record shift will be another piece of data from the original record allowing me to generate the data horizontally. The issue comes to associating the record in the vertical gallery to the column being generated in the horizontal gallery and then moving down the vertical gallery I need to pick the next column to generate. So my question about this is what type of filter could take a record from an original source and then pull up information from a specific column in the transposed data to render the horizontal records accordingly.
Here's an idea of what how it would work but I can't figure out how the filtering would work for the nested gallery, but each record of the parent gallery would relate to one column of the nested gallery, and the nested gallery would display records horizontally until all records are displayed.
| Record ID | Horizontal Generation c = Column r= record | | | | | | | | | | |
| 1 | c1/r1 | c1/r2 | c1/r3 | c1/r4 | c1/r5 | c1/r6 | c1/r7 | c1/r8 | c1/r9 | c1/r10 | c1/r11 | c1/r12 | c1/r13 |
| 2 | c2/r1 | c2/r2 | c2/r3 | c2/r4 | c2/r5 | c2/r6 | c2/r7 | c2/r8 | c2/r9 | c2/r10 | c2/r11 | c2/r12 | c2/r13 |
| 3 | c3/r1 | c3/r2 | c3/r3 | c3/r4 | c3/r5 | c3/r6 | c3/r7 | c3/r8 | c3/r9 | c3/r10 | c3/r11 | c3/r12 | c3/r13 |
| 4 | c4/r1 | c4/r2 | c4/r3 | c4/r4 | c4/r5 | c4/r6 | c4/r7 | c4/r8 | c4/r9 | c4/r10 | c4/r11 | c4/r12 | c4/r13 |
| 5 | c5/r1 | c5/r2 | c5/r3 | c5/r4 | c5/r5 | c5/r6 | c5/r7 | c5/r8 | c5/r9 | c5/r10 | c5/r11 | c5/r12 | c5/r13 |
| 6 | c6/r1 | c6/r2 | c6/r3 | c6/r4 | c6/r5 | c6/r6 | c6/r7 | c6/r8 | c6/r9 | c6/r10 | c6/r11 | c6/r12 | c6/r13 |
| 7 | c7/r1 | c7/r2 | c7/r3 | c7/r4 | c7/r5 | c7/r6 | c7/r7 | c7/r8 | c7/r9 | c7/r10 | c7/r11 | c7/r12 | c7/r13 |
| 8 | c8/r1 | c8/r2 | c8/r3 | c8/r4 | c8/r5 | c8/r6 | c8/r7 | c8/r8 | c8/r9 | c8/r10 | c8/r11 | c8/r12 | c8/r13 |
