How to use array.where formatting properly

Please see the image below:


I would like to get the Url value for a given id (id==1 in this example), however I can’t find out how to select that value. The expression in the image doesn’t work and I can’t find any information on what exactly the .where formatting expression should look like to select a value.

Hope someone can help me with this. Thanks in advance!

Replace .Url with [0].Url

You can experiment with expressions on your browser’s developer console:


This way, you know it returns an array (if I’m not mistaken)

This was the solution and I did try that before (because also found out there was an array returned by my previous expression), however for some reason it was not properly updated in the code and as a result it seemed not to be working. Now it does :slight_smile:

Thanks @Apple