Power Platform Community Forum Thread Details

hii,

I am badly stuck at 1 point in my power app where i want list of names of candidates from candidates table whose competence(column name in candidate table) match the requirements(column name in position table) in postion table. i have list of form in which shows the list of company control title, requirements in control subtitle from table position. on select of each item in list form i wish to get the list of names of candidates that match the requirements selected.

i tried various ways to do this but didnt get any result: some of which are:

filter(candidates, competence = browsegallery.selected.item)

in this syntax i received error on = sign dont know why?

filter(candidates, position[@requirements] in competence)

no result

search(candidates, subtitle.text, competence)

no result no error. here subtitle control has requirements of the selected item from browser1

basically i am trying to retrieve more than 1 row by using search string from 1 table and related data from other table.

thanks in advance i really need this soultion.

i have attached a picture of gallery form from which when clicked on 1 item i need the list of candidates.