Adding "Related Projects" in 'Staff Detail View' who are involved in it

[Sanjaykumar]

Hello community,

I am aware that by adding REF_ROWS I can take out the projects lists that staff is involved with. But my query here is, I have a project which is handled by multiple staff. So basically the ‘Staff’ column in the ‘Projects’ data table is ENUMLIST.

Now when I am in ‘Staff Details’, I need the ‘Projects Involved’ list below him/her. The error I am getting when I use REF_Rows is, cannot compare the text with a list. Because the ‘Staff’ column in the ‘Staff’ table is text type and is a key as well.

Can any senior solve this?

[Steve · Accepted solution]

Instead of REF_ROWS(), try this:

FILTER(
  "Projects",
  IN([_THISROW], [Staff])
)

This assumes the Staff column of the Projects table is an EnumList of Ref to Staff.

[Sanjaykumar]

Smooth…
That solved my issue.
Thanks, Steve.