filter gallery by sharepoint list research field

[laur1rde]

hi

my data source is a sharepoint list "INTERVENTIONS"

on this list i've a research field linked to another list (as usual i suppose)

on my apps, i'd like to filter my "INTERVENTIONS" gallery by this research field

so : SortByColumns(Filter(INTERVENTIONS;TextSearchBox3.Text in 'ID_OUVRAGES:Nomouvrage');"date_inter")

where "date_inter" is a field of my sharepoint list "INTERVENTIONS"

and "ID_OUVRAGES:Nomouvrage" is my research field of my sharepoint list "INTERVENTIONS"

it doesn't work, i don't understand why.

Is there another solution.

help me please 🙂

laurent

[v-monli-msft]

Hi @laur1rde ,

By search field, did you mean Lookup column?

Regards,

Mona

[laur1RDE24]

yes lookup column

and i've the same problem with the patch or collect fonction, but i do another post.

it don't accept the value in the lookup column.

regards