User defined place holder expression error

Getting the following expression design error when trying to create a user defined place holder. Not sure what it means.

INVALID_EXPRESSION: Expression has returned 2 XML elements. Expected exactly one.

Hi @dpeters,

As the error states, your expression returns more than one XML element. You can use square bracket notation [ ] to filter and show only one element.

For example, our SalesInvoice.Report has multiple SalesInvoiceLines records so if you use:

SalesInvoiceLines/@DiscountAmount

you get the error: INVALID_EXPRESSION: Expression has returned 5 XML elements. Expected exactly one.

Then you use filtering to show only first SalesInvoiceLines record:

SalesInvoiceLines[1]/@DiscountAmount

Thank you, that worked.

1 Like