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:

General Questions

Using Apps Using Formulas

Connecting to Data

Dataflows

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Display Form not updating Data from Filtered Gallery

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)