Setting Selected row in UD-Table - Possible?

PowerShell Universal
1 
Product: PowerShell Universal
Version: 5.6.1

Hi all, is it possible to set a UD-Table’s row selection programmatically? I need to have options selected based off of a second table’s selection. From what I can tell, there is no native support. I’ve tried a workaround by appending a ‘checked’ property to my data, and having a new-udbutton be created on the data columns -OnRender event; however, this only works if I have one page of data. Once I click on the second page, the data resets and it doesn’t work with a sync if I wrap it in a UD-Dynamic.

I figured it was a native feature, because ya know, that’s how tables normally work. Anyone have any insight / workarounds?

2

If I’ve understood you correctly, then you want to update a column that contains a checkbox based on whatever your data provides?

Here is an example If that the case:


New-UDApp -Content { 

    
    $DummyData = @()
    1..20 | ForEach-Object {
        $DummyData += [PSCustomObject]@{
            ID       = $_
            Name     = "Item $_"
            Category = "A" # A, B, C, D, E
            Price    = [math]::Round((Get-Random -Minimum 10 -Maximum 200))
            InStock  = (Get-Random -Minimum 0 -Maximum 2) -eq 1
        }
    }

    New-UDTable -Id "DummyTable" -Data $DummyData -ShowFilter -ShowSort -ShowPagination -PageSize 10 -Columns @(
        New-UDTableColumn -Property "ID"       -Title "ID"       -ShowFilter
        New-UDTableColumn -Property "Name"     -Title "Name"     -ShowFilter
        New-UDTableColumn -Property "Category" -Title "Category" -ShowFilter -FilterType select
        New-UDTableColumn -Property "Price"    -Title "Price"    -ShowSort
        New-UDTableColumn -Property "InStock"  -Title "In Stock" -ShowFilter -FilterType select
        New-UDTableColumn -Property "CheckBox" -OnRender {

            ## Your logic for if the checkbox is checked or not - Here I'm checking all rows where the price is lower than 50
            $isChecked = ([int]$EventData.Price) -lt [int]'50'
            New-UDCheckBox -Id ("chkprice_" + $EventData.Price) -Checked $isChecked

        }
    ) -InitialState @{
        orderBy = @{ field = "ID" }
    } -ShowSelection


}

This will update the checkbox based on the logic in the -onrender component of the new-udtablecolumn. So basically check any row with a price below 50. This also works across pagination.

3

Thanks for that snippit, it seemed to work. It’s very similar to what I was doing, except I was referencing a session-scope variable to see if it was checked. Not sure why, but it was out of scope and wasn’t able to get referenced. Re-calculating to see what needed to be checked on-render works.

I think there are some other underlaying issues with what I’m doing (or PSUniversal, not sure), because the table only renders 50% of the time once I wrap it in a UD-Dynamic. Statically works well, I need it in the UD-Dynamic because I need it to refresh based on the selection in the other table. Works after a couple page refreshes.

Anyways I ended up just writing this in C# Windows Form the other day and moved all of my Active Directory and SQL calls into an endpoint on PSUniversal that I just call from the desktop app. It’s probably something that I’m doing, but the webapp just wasn’t reliable enough and the winforms just works.

Anyways, thanks again for your response!