Multi-Lookup fields (more than one lookup value) can be formatted. The values come back as an array which lets us use the advanced formatting
forEach option. Unfortunately, projected fields for any multi select column as primary won’t come back as an array. Instead, the values come back as a single string with a separator (;). While you can still apply formatting, you can’t deal with each value individually with the
forEach as before.
I’ve provided additional details and a sample implementation of how you might solve this on this answer: https://sharepoint.stackexchange.com/a/290961/2881
In summary, we have to get creative with a series of conditional elements that are extracting values using a complex combination of
indexOf operators. This approach does work but has some drawbacks:
- It’s super complex to read/write
- It can only handle a fixed set of values with each value having increasingly complex formulas to extract those values