Table A: Names - unique id, full name, other fields.
Table B: Invoices - unique id, name.id (unique id from Table A), other fields
Table A's Unique ID exists as a field in Table B but not the full name field of the individual.
Trying to display the list of invoices from Table B with a Search Box input for the full name from Table A.
Tried Search(Table B, Text(LookUp(Table A, full name = SearchBoxInput.Text, unique id), name.id)
Returned nothing.
There's another solution that uses Filter provided here: https://powerusers.microsoft.com/t5/Building-Power-Apps/Lookup-Nest-Search/m-p/477959
Maybe filter can work instead. Let me know what you think, thanks!
