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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

MJain 2,450 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Paulos29 39 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

MJain 2,450 on at

Like (0)

Report

Hi @Paulos29 ,

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

Thanks

Was this reply helpful? Yes No
Verified answer

Paulos29 39 on at

Like (0)

Report

Manish, YOU ARE A GENIUS!

I salute you , Sir!

Thank you

Was this reply helpful? Yes No
ShaishavM 13 on at

Like (0)

Report

Hi @ManishJain
I have similar issue, field has a space, I tried using item().['field name'], however I am getting "The expression is invalid" error.

Appreciate your help.

TIA
S Merchant

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

Hi @shaimerc ,

you have used period instead of question mark.

item().['field name'] should be item()?['field name']

Thanks

Was this reply helpful? Yes No
ShaishavM 13 on at

Like (0)

Report

Hi @ManishJain yes, made that mistake. All fine now.
Thanks!👍👌

Was this reply helpful? Yes No