cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Populating a Gallery inside Components using SQL Table

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

554.PNG

 

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.

 

555.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
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
Community Support
Community Support

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

554.PNG

 

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.

 

555.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
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

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.

 

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (48,677)