The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria. Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup