Showing results for 
Search instead for 
Did you mean: 

Accessing a nested object to display as a column in a gallery table

I have a gallery table populated by a response from a custom connector. So far, my gallery table has used the top layered properties. I want to display nested properties as columns, too. So where I normally have ThisItem.Property1 for one column, I'd like to do ThisItem.Property2.Property2A for another column. However, Property2 doesn't even show up as an option to access using dot notation, let alone Property2.Property2A. Is this at all possible or do I have to somehow create two tables and merge them (one for the top layer properties, one for the nested properties)?



"jsonResponse": [
{"Property1": "foo",
"Property2": {
  "Property2A": "bar",
  "Property2B": "baz"
 {"Property1": "foo2",
  "Property2": {
   "Property2A": "bar2",
   "Property2B": "baz2"


Community Support
Community Support

Hi @aec2018 ,


Could you show me the settings of your Gallery data source?


I did a simple test with two ways of data source, one is to put the table structure you show directly into the Gallery items property, and the other creates a collection to put into items. I have tests for your reference, you could refer to the screenshot below:




Best Regards,

Jessica Gu


Hi @v-JessicaG-msft ,


Thanks for the response. This is the Items property of my gallery. It's a collection (competeRegionMappingData) made of the response from my custom connector which returns a JSON response from our API. There is some test logic for filtering in there you can ignore:




Each column here comes from ThisItem. For example, this is my Azure Billing Region column coming from ThisItem.AzureBillingRegion:




One property in the response is nested and I need each nested property to become its own column. It would make sense to be able to use ThisItem.azureRegion.FriendlyName from the response:



as the Text property of a column but azureRegion isn't even available as a property of ThisItem:




I do see that your example is using dot notation to get to nested items. Am I doing something differently than you that I'm not quite seeing? Thanks.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

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

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 (3,129)