Populating a Gallery inside Components using SQL Table

[pralikab931]

I have a Gallery inside a component. This gallery should get populated with an SQL table and be filtered in different screens, according to the data that needs to be shows.

Currently, I am adding an Input property 'Table' into my component. Name of the component is 'TableDetails'. I am then specifying the gallery items as Component.TableDetails.

In the screen where this component is being used, I'm specifying 'TableDetails' as [dbo].[SQL_Table_Name] but my gallery remains blank.

Any idea what I'm doing wrong and how to solve this error?

[v-yutliu-msft · Accepted solution]

Hi @pralikab931 ,

Do you want to display table in a gallery inside a component?

I've made a similar test but not met the problem like your description.

Here's my test , please check where's your problem:

1)connect app with sql table(make sure that you have permission on this table)

2)create a component, named Component1

create a custom property for this component

insert a gallery inside the component

set the gallery's Items:

Component1.TableDetails

2)insert the component in your app

set the component's TableDetails property to the sql table that you want

Then the gallery will display the sql table.

Best regards,

[pralikab931]

Thanks a lot! I was doing the same thing but the gallery wouldn't populate. I then deleted and added a new gallery and suddenly things worked. I don't know why it worked on a new gallery and not on the previous one.