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.
This is all that's available to me. When I compose the filter array body, this is what's returned:
When I use the custom columns option, you can see I don't have the option to select these fields.
I'm obviously not understanding how this works. Can someone help explain it?
Solved! Go to Solution.
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,
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,
@v-bacao-msft thank you so much. Targeting the property in the expression worked just as you showed.
User | Count |
---|---|
89 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
138 | |
56 | |
47 | |
36 | |
26 |