Have a simple gallery that displays all records from a sharepoint list called Task
I have added an additional field (named Taskname) to the gallery that looks up a matching Name from another sharepoint list called Task_ID
LookUp('Task_ID ', ID = ThisItem.ID, Name)
I only want to display those records that have a Name and cannot work out how to filter in the gallery
tried this but doesnt work:
Filter(Task, Not(IsBlank(Taskname)))
Any help appreciated

Report
All responses (
Answers (