I’m running into an issue related to how icons / emojis are handled when included in a column that is later used as a lookup.
Specifically what I did is:
Created some pages that have icons
Used @references to those pages in a table display column, creating links. This works fine.
Tried to use that display column as a lookup / select list value in another table. This does not work fine.
What happens is that the icon’s internal code gets appended to the end of the page title. I’m OK with the icon itself not getting carried over to the pill-like styling of a lookup column, but I don’t want this gibberish text appended.
This also happens if the column in question is just a normal hyperlink to the page instead of an @reference.
Below is a toy example that shows this happening.
Any workarounds? Again, I don’t mind that the icons aren’t coming through to the lookup, I just don’t want the random strings being appended to the values.
The only way I know of as of now to get your page names (with icons) into a select list is by using the Doc Explorer pack. The benefit of using the pack is that it also continually and dynamically updates your select list so its ALWAYS up to date with the pages in your doc
Heres a quick video of how to make it happen:
And if you need to know more about the Doc Explorer pack and how to install it, heres an example doc with lots of helpful resources
Aside from that, and if you don’t care about the icons, you would need to create a formula column in the source table that’s uses some regex() to pull out JUST the name itself. I can help set that up to if that’s or more interest to you!