How to insert data from a table in the Gallery screen?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am having doubts on how I can code or read data from a table.

I would like to see in the first option the "Item_Code" field and in the second field below the name "Item_Name".

It's important to note that you would not like to affect the search and ordering code for the gallery.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

As long as you have those columns in your DataSource and you have connected your DataSource to the Gallery, you can quickly edit those labels in the "Fields - Edit" under the Gallery properties on the right properties pane.

There you can select whatever columns you have in your DataSource to display them.

I hope that is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @RandyHayes for your quick answer.

But...I'm not seeing exactly the field mentioned. Would these be featured? And what code would you use to extract the information from the table?

Appreciate your time.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

You are using CutomGallerySample as your DataSource! Pretty sure you don't want the built-in sample data to be your data. You will need to put your DataSource in the property and adjust your formula to the columns that are in your datasource.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @RandyHayes one more time! Thank you!

So...I took out a "Search Item" formula from the field and adding the name of the database. It worked as you instructed.
But I have another issue:
- How do I add a search item? (a mean the code and where?...on "TextSearchBox4"???

Once again appreciate your time.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Anonymous

You need not worry about the Textbox to do anything. In PowerApps, things "respond" to other controls, controls don't usually alter other things.

So, looking at your original default formula for your Gallery Items Property is the place to start.

You can see that it had two functions in it - the SortByColumns and the Search function. You will need to apply those to your Gallery Items property as well.

Consider altering this formula for your needs:

SortByColumns( Search(yourDataSource, TextSearchBox4.Text, "yourColumnYouWantToSearchInQuotes"), "yourColumnYouWantToSortByInQuotes", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending) )

This will give you similar functionality for searching and sorting that you were asking for, but you need to apply your datasource and your columns.