Bridge - Extracting a filtered array

Paul.Koetke

Hello,

I have a multi-tier SCC solution and I want to update a dropdown column in projects intake sheet with only the names of programs that have already been provisioned. Here is my report:

Looks, great in Bridge when I use the Smartsheet: Get Report element, but the whole thing falls apart in the Extract Field From Array element.

Here is my Extract Field From Array configuration.

I can't figure out what wrong. I've tried every possible combination of fields and no success.

Any thoughts? Thanks in advance!

Genevieve P.

Hi @Paul.Koetke

What do you see when you expand each Object in the Rows array?

I see that your key has cells.Program Name.value, however in my Rows array from a Report, it lists a column ID instead of a typed out name.

This is the key path I used in my extract module:

It's the same number that appears as the virtualColumnId under that object. Let me know if adjusting your key works for you!

Cheers,

Genevieve

Genevieve P.

Hi @Paul.Koetke

What do you see when you expand each Object in the Rows array?

I see that your key has cells.Program Name.value, however in my Rows array from a Report, it lists a column ID instead of a typed out name.

This is the key path I used in my extract module:

It's the same number that appears as the virtualColumnId under that object. Let me know if adjusting your key works for you!

Cheers,

Genevieve

Paul.Koetke

@Genevieve P. Thank you!! That did it!

I would like to take this opportunity to thank you for all the previous Bridge posts from other people you have answered as well. I have been learning Bridge and reading all the questions and your responses in the community, which have all been extremely helpful.

Thank you for getting me over this last little hump to complete this workflow!

Genevieve P.

Hey @Paul.Koetke

I'm so glad to hear that worked for you! And very glad I could help - with this response and previous questions. I love seeing all the ways Bridge is being used. 🙂

You've likely already seen this, but the Help Center has a handful of Bridge workflow examples that I've found useful as practice guides and training material:

https://help.smartsheet.com/topics/Bridge%20Templates%20and%20Workflow%20Examples/Bridge%20by%20Smartsheet

Cheers,

Genevieve