FindRow with multiple inputs

[Matt-1edd]

Hello 's,

I'm probably getting tripped up on syntax for find row:

=FINDROW($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "HC-VendorSetupTeam")>0

Returns true or false if "HC-VendorSetupTeam is found" if it is a user is in that group.

I need to check if a user is in one or more groups. I looked around the docs and then tried to combine it with FILTER() to get the results but I'm just not finding it.

How can this done?

[Alyssa]

Hi @Matt-1edd

Happy to help! For this, you can use the AND() operator to check if the user is in different groups. The formula would look something like:

AND((FILTER($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "Group A")>0),(FILTER($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "Group B")>0))

The formula will return true if both arguments are true (user is in both groups).

[Matt-1edd]

@Alyssa

AND((FILTER($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "Group A")>0),(FILTER($[SYS_USER_GROUPS], "$[SYS_USER_GROUPS][Name] = %", "Group B")>0))

Thanks @Alyssa I'm not used to the syntax yet, I switched it to OR and got exactly what I needed!

[Alyssa]

@Matt-1edd Great

You're welcome, I'm happy that helped!