Nested storage and display of data

[Anonymous]

Hello, how can i make a column in a SharePoint List be the data of another SharePoint List(i tried to add a column type - already available data, but for some reason not all fields are visible there, it is not clear what this is connected with), and what it would be was for each line its own, can this be done or not? And then how can i bind such a structure to PowerApps?. I will explain it differently, i am trying to achieve that in the PowerApps application in each item of the gallery there is a separate gallery, can i do this through data storage in SharePoint?

[RandyHayes]

@Anonymous 

Yes, you seem to be referring to having a column in your PowerApp gallery contain another table of values that can be used for another gallery.

Example:

Items property of GalleryA -  

   AddColumns(someDataSource, 

       "anotherTable", someOtherDataSource

  )

You would then have a table that has all the items from someDataSource and another column in that table that has all the contents of someOtherDataSource.

I hope this is helpful for you.

[Anonymous]

Yes, you understood correctly, but I can’t figure out how to store it? the data is in the SharePoint List, and how to make the data of one table the data of the column of another table, while each field of this column has its own data

[RandyHayes]

@Anonymous 

I'm not sure what you mean by "store it".  What do you want to store and where?

As shown in my formula, there are two lists involved in that example.

Can you expand more on what you are trying to do and what you expect?

[Anonymous]

I have two lists in SharePoint, I need to make my column the data of another list, so that I can then display them in PowerApps, so that each item in the gallery has its own data (that is, different)

[RandyHayes]

@Anonymous 

Okay.  What is the relationship of one list to the other?

And, you keep mentioning "Storing" it.  What do you mean by that?  You are already storing the data in your two lists?

[Anonymous]

Yes, they are in lists, but how can I make one list part of the data of another list? as it were, it turned out to be nested, and to make sure that each row of data had its own separate list of data.
So that when I click on an item in the gallery, I would go to another gallery that belongs to this item?

[RandyHayes]

@Anonymous 

Yes, so as I originally replied...

  AddColumns(someDataSource, 

       "anotherTable", someOtherDataSource

  )

This will have your original datasource records with an added column called "anotherTable" that has the records of the other datasource.

In this case, you would have Gallery1 with the above formula for the Items property.

And another Gallery with an Items property of Gallery1.Selected.anotherTable

[Anonymous]

I understood this, but they will all be displayed, but I need the data to depend on the column of another gallery, something like this Form DataSource =

LookUp(EnterpriseViolations; ObjectMiningID = GalleryMining.Selected.ID)

I display it in the edit form from the gallery where the column ID matches the ID with data from another sheet

[RandyHayes · Accepted solution]

@Anonymous 

No, you would not see them all together.  They would be part of a column in the primary record.

But, I am assuming that GalleryViolations is the primary gallery and you have another gallery you want to see the records from EnterpriseViolations in that gallery based on the selected item in the primary?

If so, then you only need to set the Items property on the second Gallery to: 

   Filter(EnterpriseViolations; ObjectMiningID = GalleryViolations.Selected.ID)