Answered

Nested storage and display of data

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (37)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, you understood me correctly (I slightly corrected the data), only I need to display it in the edit form, since it should be repeated for each element of the gallery and there was a possibility of editing

Was this reply helpful? Yes No