I'm creating a database view to facilitate exporting data and having custom column names.
I've figured out how to get the columns named and joined with sys_user twice for the column names I want. That is working without issue.
Now, I'm trying to join a list column. I found a previous post that used instr() and added a .toString() to the list field. However, I'm not getting the desired result, so I must be missing something. I have also tried without the .toString(), which gives me an error.
I aim to have the additional assignees on each row with the UPN associated with the record from sys_user. I need the UPN to match the M365 profile in Power Automate.
Is there any recommendation on how to achieve this goal?
I referenced this to figure out the use of instr(): Solved: instr() is not working in Database view - list typ... - ServiceNow Community
