web

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

News and Announcements icon

Power Platform CommunityForums Power Apps My display form return...

Power Apps

Unanswered

My display form return blanks after selecting option from gallery

(0) Share

Report

Report

Posted on by npinot2002

19

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.

So when I click the arrow on the gallery to show a display form it has no values and only returns the column names

I saw to use the following syntax with Lookup() cause you cannot use gallery1.selected since it has a filter

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

But this does not work. I dont know why, I think its cause I dont have a lookup column since my data source is an excel?

I just want to be able to display the data on the form for whatever record I select from the gallery.

Thanks in advanced!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

npinot2002 19 on at

Like (0)

Report
Copy link

Link copied!

This does not work because of the AddColumns() in the Filter()

Was this reply helpful? Yes No
npinot2002 19 on at

Like (0)

Report
Copy link

Link copied!

This solution doesn't work either, it gives me this error

Invalid formula. Expected a value compatible with 'Data Source'

Also how do you double-check that the data types match?

Was this reply helpful? Yes No
npinot2002 19 on at

Like (0)

Report
Copy link

Link copied!
My table has a unique column called 'index' so that means that my temporary table should also have index, but
LookUp(Table2, ID = Gallery1.Selected.ID)
Does not work

Was this reply helpful? Yes No

Join the conversation