Skip to main content
Level 2
Jul 27, 2026 10:45 AM UTC
Solved

Internal Look up multi-select

When i convert an internal lookup field to multi-select I am no longer able to group by that field in a report. Is there any way to have multi-select internal look up and group by that field?

    ninoskuflic
    ninoskuflicAccepted solution
    Level 6
    Jul 27, 2026 11:57 AM UTC

    Hi ​@CharlieHam,

    you can group with text mode with syntax like this: 

    textmode=true
    group.0.displayname=Project Name
    group.0.valueexpression={DE:Project Name}
    group.0.valueformat=HTML

    This should give you an output similar to this:

     

    In my example, Project Name is a multi-select Internal Lookup field that sits on a custom form.

    If this solved your issue, please mark it as solved so others can find the solution faster.

    2 replies

    ninoskuflic
    ninoskuflicAccepted solution
    Level 6
    Jul 27, 2026 11:57 AM UTC

    Hi ​@CharlieHam,

    you can group with text mode with syntax like this: 

    textmode=true
    group.0.displayname=Project Name
    group.0.valueexpression={DE:Project Name}
    group.0.valueformat=HTML

    This should give you an output similar to this:

     

    In my example, Project Name is a multi-select Internal Lookup field that sits on a custom form.

    Translate
    If this solved your issue, please mark it as solved so others can find the solution faster.
    Level 2
    Jul 28, 2026 3:04 PM UTC

    thanks - I’ll try this out.

    Translate