cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nBow
Helper I
Helper I

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

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 IDHorizontal Generation c = Column r= record          
1c1/r1c1/r2c1/r3c1/r4c1/r5c1/r6c1/r7c1/r8c1/r9c1/r10c1/r11c1/r12c1/r13
2c2/r1c2/r2c2/r3c2/r4c2/r5c2/r6c2/r7c2/r8c2/r9c2/r10c2/r11c2/r12c2/r13
3c3/r1c3/r2c3/r3c3/r4c3/r5c3/r6c3/r7c3/r8c3/r9c3/r10c3/r11c3/r12c3/r13
4c4/r1c4/r2c4/r3c4/r4c4/r5c4/r6c4/r7c4/r8c4/r9c4/r10c4/r11c4/r12c4/r13
5c5/r1c5/r2c5/r3c5/r4c5/r5c5/r6c5/r7c5/r8c5/r9c5/r10c5/r11c5/r12c5/r13
6c6/r1c6/r2c6/r3c6/r4c6/r5c6/r6c6/r7c6/r8c6/r9c6/r10c6/r11c6/r12c6/r13
7c7/r1c7/r2c7/r3c7/r4c7/r5c7/r6c7/r7c7/r8c7/r9c7/r10c7/r11c7/r12c7/r13
8c8/r1c8/r2c8/r3c8/r4c8/r5c8/r6c8/r7c8/r8c8/r9c8/r10c8/r11c8/r12c8/r13

 

2 REPLIES 2
cha_cha
Resident Rockstar
Resident Rockstar

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 

 
Just in case you my answer 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 

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,595)