How to correctly extract name of column from Json schema for Item(). expression when column name has spaces?

[Paulos29]

I have a flow that collects some bits of information from json snippet to build table with 'Create HTML table' action:

Schema:

'Work Type' and 'Fee ' column have got some space in the name.

How do i specify that space in the expression Item() to get the data from that column?

Item().Work Type doesn't work. I tried various combinations to cater for that space ,such as: 

& " " &, _x0020x_,$,? ,* ect. but nothing works

[ManishJain]

Hi @Paulos29 ,

You need to use outputs('ActionName')?['body/Work Type'] , if you are processing multiple objects it will go inside For Each loop. For better clarity post your JSON and screenshot of Flow.

Thanks

[Paulos29]

Hi Manish,

Here is the flow part that attempt to build the table off the Filter Array output:

Expanded view:

I am able to collect values for column Client, Country , Year and Recurring (using expressions Item().Client, Item().Country etc. in Value section of HTML table but the same approach does not work for

Item().Work Type and Item().Fee

as there are a spaces in the names of these 2 columns in the json schema (as per below):

I need to figure out what to input in place of space for Item().Work Type and Item().Fee (which has space at the end of string 'Fee ' in json schema.

[ManishJain · Accepted solution]

Hi @Paulos29 ,

You can use item()?['Work Type'] for it. Just put this in expression.

Thanks

[Paulos29]

Manish, YOU ARE A GENIUS!

I salute you , Sir! 

Thank you