PowerShell 7.3 - Difficulty Writing to CSV with Nested Objects and Custom Properties
I'm trying to configure I'm a bit lost with This might be a silly question, but I'm trying to export a collection of nested objects to a CSV file using PowerShell 7.3, but I'm running into issues with the custom properties not being formatted correctly... Specifically, I have an array of custom objects where each object contains a property that is itself an array of objects. When I attempt to convert this to CSV using `Export-Csv`, it flattens the nested structures in a way that makes the output unusable. Here’s a simplified version of what I’m working with: ```powershell $users = @( [PSCustomObject]@{ Name = 'Alice'; Roles = @( [PSCustomObject]@{ RoleName = 'Admin'; Permissions = 'All' }, [PSCustomObject]@{ RoleName = 'User'; Permissions = 'Read' } ) }, [PSCustomObject]@{ Name = 'Bob'; Roles = @( [PSCustomObject]@{ RoleName = 'User'; Permissions = 'Read' } ) } ) ``` When I try to export this using: ```powershell $users | Export-Csv -Path 'users.csv' -NoTypeInformation ``` The `Roles` property gets flattened into a string which contains something like `@{RoleName=Admin; Permissions=All}, @{RoleName=User; Permissions=Read}` instead of properly formatting each role on a new line or creating separate columns. I’ve tried using `Select-Object` to create a custom view, but I need to seem to get the right syntax to properly expand these nested properties. I've looked into using `ConvertTo-Csv` with a more complex select statement, but I just can’t get it to yield the output I’m looking for. Is there a straightforward way to achieve this in PowerShell? Any insights would be greatly appreciated! What am I doing wrong? I'm using Powershell 3.10 in this project. What's the correct way to implement this? Any ideas what could be causing this?