cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How can I access to the table ?

Hello All, 

 

I have A collection within is a Table. So my Question is how can i access to the tables?

CollectionTable.png 

                            (name,firma, s)

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @Anonymous ,

 

You can make a collection to show in the Gallery control for example. Just set the collection name in the Items property of the gallery control.

But collection is also one kind of variables in PowerApps. All variables are held in memory while the app runs. After the app closes, the values that the variables held are lost.

You can store the contents of a variable in a data source by using the Patch or Collect functions. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Jeff_Thorpe
Super User
Super User

It depends on where you want to display the data. In general you use dot notation. 

example: First('CollectionName').Namebes.name will return the table of names from the first record in the collection



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
v-monli-msft
Community Support
Community Support

Hi @Anonymous ,

 

You can make a collection to show in the Gallery control for example. Just set the collection name in the Items property of the gallery control.

But collection is also one kind of variables in PowerApps. All variables are held in memory while the app runs. After the app closes, the values that the variables held are lost.

You can store the contents of a variable in a data source by using the Patch or Collect functions. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,672)