Filter Specific value within ValueCollection

Question

Filter Specific value within ValueCollection

Nandan Hegde 36,886 MVP Volunteer Moderator

Hello All,

I have a variable in PowerShell with the below type

Attached is the output value of that variable
237725-lsapi.txt

Now the need is to get the referencename within Next value wherever it is available .

How can one filter those specific values

@Rich Matheisen

Rich Matheisen 48,116 Reputation points

2022-09-05T15:05:29.197+00:00

You have a variable of that type? Or do you have a Dictionary object type that has ValueCollection as a member?

Dictionary objects have a method named "GetEnumerator()" that will iterate through the key/value pairs.

You'll have to provide context to your question if you want more of an answer than that.

2 answers

Your answer

Rich Matheisen 48,116 Reputation points

2022-09-05T15:05:29.197+00:00

You have a variable of that type? Or do you have a Dictionary object type that has ValueCollection as a member?

Dictionary objects have a method named "GetEnumerator()" that will iterate through the key/value pairs.

You'll have to provide context to your question if you want more of an answer than that.

Answer 1

Try
$yourVariable.Keys | % { $yourVariable[$_]['Next'] }
to get the value in "Next". Then you should "only" parse the content in "Next" to get the "referenceName" property.

I've tried to convert it via JSON-deserialisation (ConvertFrom-Json), but it failed, because the content is not a valid JSON serialized object, see (missing comma between properties!):
{"type": "AzureKeyVaultSecret" "store": {

// ValueCollection: I had a similar issue with a result of type ValueCollection in PowerShell, and this approach works in my case. In my case the object with type ValueCollection was returned by a CRM FetchXML query via the GetEntityDataByFetchSearch method. Based on the documentation, the return type should have been Dictionary<String,Dictionary<String,Object>.

Hope it helps...

Answer 2

Hi Nandanhegde-7720,,

Thank you for posting your query.

To answer your query kindly check this link https://learn.microsoft.com/en-us/dotnet/api/system.collections.generic.dictionary-2.valuecollection?view=net-6.0 for the command provided below.

public sealed class Dictionary<TKey,TValue>.ValueCollection : System.Collections.Generic.ICollection<TValue>, System.Collections.Generic.IEnumerable<TValue>, System.Collections.Generic.IReadOnlyCollection<TValue>, System.Collections.ICollection

--------------------------------------------------------------------------------------------------------------------------------------------

If the answer is helpful kindly click "Accept as Answer" and upvote it. Thanks.