Unanswered

Can't figure out how to target properties in returned item

(0) Share

Report

Posted on by notj

782

I'm having a hard time returning the parameters output from a filter array. I can output the body to an html table, but only if I use automatic columns. If I switch it to custom columns, I can't target the parameters in the filter array item.

Here's some screenshots to show what I mean.

filter outputs.png

This is all that's available to me. When I compose the filter array body, this is what's returned:
returned body.png

When I use the custom columns option, you can see I don't have the option to select these fields.

custom columns.png

I'm obviously not understanding how this works. Can someone help explain it?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-bacao-msft on at

Like (0)

Report

Hi @notj ,

The first method is that you need to get the field value using an expression like item()['ColumnName'].

Like:

Another method is that you first use Parse JSON to parse the body of the Filter array, and then you can use Dynamic content to configure the Create Html table action.

a-thesis-on-the-parse-json-action-in-microsoft-flow

handling-json-in-microsoft-flow

Best Regards,

Was this reply helpful? Yes No
notj 782 on at

Like (0)

Report

@v-bacao-msft thank you so much. Targeting the property in the expression worked just as you showed.

Was this reply helpful? Yes No