Nested Galleries and Transposed Data to generate an editable table in Powerapps canvas.

[nBow]

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

[cha_cha]

Hello @nBow 

Here's a short demonstration recorded of how your idea might work.

https://youtu.be/e5ibZ0RWjeg

Here's the code for the horizontal items:

Table(
    {colName: ThisItem.Lot_Number, colBackground: RGBA(200,200,200,1)},
    {colName: ThisItem.NrPacks,colBackground: RGBA(200,200,0,1)},
    {colName: ThisItem.'Actual Weight',colBackground: RGBA(200,200,200,1)},
    {colName: ThisItem.Sealed.Value, colBackground: RGBA(200,200,200,1)}
)

---

✔️	Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION.  This helps community members if they experience a similar issue in the future.

🔗	🕸bistek.space  🐦 @cha_bistek  📺 @BisTekSpace

[nBow]

Thank you for the response and video! I'm going to try to apply this solution to my app today, lets hope I can get it working.