Display Form not updating Data from Filtered Gallery

(0) Share

Report

Posted on by npinot2002

So I have a gallery that has the following filter so it can be used with search bar

Filter(AddColumns(Table2, "ColumnName",'Column Name'),
 StartsWith(ColumnName, SearchbBox.Text)
)

I added a column because the filter does not work with column names with spaces in it.

I changed the OnSelect property of the arrow to the following below:

Select(Parent) ; Set(varColSelecred, ThisItem.col)

And the Items property of the form to

LookUp(Table2, varColSelected = Gallery1.Selected.col)

This solution on displays the first record of the excel file, even when clicking other records in the gallery. I did it this way because setting the forms' item property to Gallery1.Selected Did not work. I have been stuck on this for the past 2 weeks.

I need a solution to be able to display a form from a selection from a filtered galllery.

Please Help!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
HI @npinot2002,

First of all, please check the Default property of your Gallery, make sure that it is set to {}, which will make Gallery.Selected be what you select from the Gallery instead of the first record by default.

Then set the Item property of the Form as:

LookUp(Table2, col= Gallery1.Selected.col)

Was this reply helpful? Yes No