New-UDForm Filter question

PowerShell Universal
1

So I am displaying some data that comes from a json blob that looks like this.

[
{
    "Id": "ea0c6a8f-ffdd-41ba-9a19-a855865b0f35",
    "ApplicationName": "Wibble",
    "Status": "Active",
    "BusinessUnit": "unit1",
    "Groups": [
      "GroupName1",
      "GroupName2"
    ]
  },
  {
    "Id": "1d3f147a-59b2-40fa-87ba-43b44768a2eb",
    "ApplicationName": "wobble",
    "Status": "Active",
    "BusinessUnit": "unit1",
    "Groups": [
      "groupName3",
      "groupName4"
    ]
  }
]

For the groups column, I tried to flatten the list to a csv so I could search it like this.

New-UDTableColumn -Property Groups -Title 'Groups' -Filter -FilterType text -Render {
    [system.String]::Join(", ", [Array]$EventData.Groups)
 }

Unfortunately, it doesn’t seem to be searchable.
If I just leave the Groups as a Property I only get System.Object[] rendered in the column.

Is there any way I could get the column search to work?

Thanks!

2

Have you tried adding "-IncludeInSearch " to the Column?

$Columns = New-UDTableColumn -Property Groups -Title 'Groups' -Filter -FilterType text -IncludeInSearch -Render {
    [system.String]::Join(", ", [Array]$EventData.Groups)
}
New-UDTable -Data $Data -Columns $Columns -ShowSearch
3

I did try that. No luck, unfortunately.

4

OK so I fixed this by converting the group data into csv before it gets serialized into JSON.