Extract Data From Column That Contains List and Record Types

Question

I have a column in a table that contains both List and Record data types. How can I convert the Records into a list type so the column is consistent to the point where I can easily convert it into a single column with each record separated by commas?

ShareRoot.Access
List
List
Record
List
Record

The List types look similar to the following:

And the record looks similar to this:

Answer 1

Add a custom column and build up the string like this (first part provided but you can do the rest)

if Value.Is([ShareRoot.Access], List.Type) then [ShareRoot.Access]  else {"@FileSystemRights="& Record.Field([ShareRoot.Access], "FileSystemRights")}