Link to filter view not populating

I am trying to either edit an existing record, or create a new record with the below expression.  The create new works great, but the edit existing does not populate.  Any idea why?  Do I need to use a slice?

IF(COUNT(SELECT(Employee override master table[Employee ID], [Employee ID] = [_THISROW].[Employee ID])) > 0,

LINKTOFILTEREDVIEW("Employee Override view", [Employee ID] = [_THISROW].[Employee ID]),

LINKTOFORM("Employee Override view",
"Employee ID", [_THISROW].[Employee ID],
"Preferred Name", [_THISROW].[Preferred Name],
"Job Profile", [_THISROW].[Job Profile],
"Job Family", [_THISROW].[Job Family Group],
"Job Category", [_THISROW].[Job Category],
"Work Location Profile", [_THISROW].[Work Location Profile],
"File Source", CONCATENATE("RTO App: ", USEREMAIL())
)

)

Solved Solved
0 2 82
1 ACCEPTED SOLUTION

You wouldn't use LINKTOFILTEREDVIEW() in this case.  The expression you want is:

LINKTOROW([Employee ID],"Employee Override view")

View solution in original post

2 REPLIES 2

You wouldn't use LINKTOFILTEREDVIEW() in this case.  The expression you want is:

LINKTOROW([Employee ID],"Employee Override view")

Of course!  My brain must have been tired at the end of the day, thanks for the reminder.

Top Labels in this Space