It looks like I was wrong - it might be null because it’s detecting the user id with quotes as "randomID", which you can use TRIM(TOTEXT(user), '"') to replace. However, in show message, it’s still reporting the name as part of the user object. I don’t think there’s an easy way to pull the user’s plain text name without:
Using the current logged in user, which you can extract the name of.
Using some form of secondary storage where you store the user object and a plain text name representation (i.e. if you pull from a user column in a table you would also store the plain text name).
I’m going to follow up on an open product suggestion we have to extract the user’s name from their user object.
Yeah, I think we need a way to extract the name reliably from a user object. That’s how I’m planning to structure the suggestion. Either by accessing the child attribute similar to what is possible with the current logged-in user or through some expression.