Form not displaying selected item from gallery

[neill_long]

I have a gallery that has a filter on it and when i select a record that i searched for, the view form and editform is not displaying the records details.

In the item properpty I have:

TemplateGalleryList1.Selected

The filter on the gallery is:

Filter(
AddColumns('Digital Skills',"Present",Sum(ForAll(Split(TextInput3.Text," "),If(IsBlank(Find(Result,Lower(Key_x0020_Skills_x0020_2))),0,1)),Value)),
Present=CountRows(Split(TextInput3.Text," "))
)

If there is no filter, the forms display fine, so i suspect it has something to do with the filter.  Any suggestions on how i can fix this?

thanks

Alistair

[Drrickryp · Accepted solution]

Hi @neill_long,

When you modify the datasource of a gallery by filtering, adding columns, etc.  it is no longer identical to the datasource in the View and Edit forms.  To get around that problem you need to change the Item property in the View and Edit forms to be more specific. You would use Lookup('Digital Skills', ID=TemplateGalleryList1.Selected.ID) instead of just TemplateGalleryList1.Selected.   

[Anonymous]

Hi Alistair,

Looks like you are trying to do a lot in the add columns, looking at the Filter which I agree looks like the issue, I would try and throw that whole segment of code into a collection and see what comes back.

Then start breaking up the formula into sections to test what works and what does not. Due to the complexity I cannot replecate what you're trying to achieve without seeing more information.

[neill_long]

Thanks @Drrickryp worked great.