web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Populating a Gallery i...

Power Apps

Answered

Populating a Gallery inside Components using SQL Table

(0) Share

Report

Report

Posted on by pralikab931

18

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?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Join the conversation