Hi,
I am trying to create a collection from a SP list. I would like to have only 3 of the columns: "ID" (number) "Title"(text) and "Owner" (user/group). The syntaxis is as follow:
ClearCollect(colReport, ShowColumns(MySPList, "ID", "Title", "Owner")
That create the collection but with two issues:
- Everything is a type text in the collection. When I use ID I have to convert it using Value().
- The Owner column is a record and displaying the following icon
. I would like to add here the DisplayName od the record, but I haven't found the way of doing it. Tried Owner.DisplayName but it is not working.
Any idea on how to solve this?
Thanks