Crow Canyon Software Forum
Generating a Word Document with a 'Person or Group' column
Quote from pf-amalin on April 6, 2022, 5:20 pmWe have a workflow that Generates a Word Document and it does a great job, but I've run into something that I can't figure out. When merging a 'Person or Group' column the Account Name is used rather than the Display Name. For example, if the name in the column is 'John Doe', the document displays 'jdoe' (his account name) rather than 'John Doe'. I've looked at the $parseuservalue() function but it doesn't seem to apply in this case. Is there a way I can display 'John Doe' in the document rather than 'jdoe'?
We have a workflow that Generates a Word Document and it does a great job, but I've run into something that I can't figure out. When merging a 'Person or Group' column the Account Name is used rather than the Display Name. For example, if the name in the column is 'John Doe', the document displays 'jdoe' (his account name) rather than 'John Doe'. I've looked at the $parseuservalue() function but it doesn't seem to apply in this case. Is there a way I can display 'John Doe' in the document rather than 'jdoe'?
Quote from pf-amalin on April 7, 2022, 1:44 pmMore info...
I tried it again with a new Custom Action on the same Library and Item and it used the Display name as expected ('John Doe'). So it seems to only affects the Workflow Generate Document action.
More info...
I tried it again with a new Custom Action on the same Library and Item and it used the Display name as expected ('John Doe'). So it seems to only affects the Workflow Generate Document action.
Quote from supportTeam on April 8, 2022, 1:11 amHi,
Please use formatvalue function in NITRO Workflows to get the display name from person or group column.
Syntax: $formatvalue([ColumnDisplayName|ColumnInternalName])
Ex: $formatvalue([Requester|Requester])
Hi,
Please use formatvalue function in NITRO Workflows to get the display name from person or group column.
Syntax: $formatvalue([ColumnDisplayName|ColumnInternalName])
Ex: $formatvalue([Requester|Requester])