Unanswered

Conditional xpath formatDateTime

(0) Share

Report

Posted on by sasrsc

678

formatDateTime(xpath(outputs('XMLRegulations'),concat('//Array[ID/text()="', item()['ID'],'"]/EndDate/text()'))?[0],'d','en-US')

This is being done in a select statement with mapping to create a variable.
That works if there's a value, but if there's no value I get an error, because it's trying to do a formatDateTime on null and barks at that.
So how would I add a conditional piece to it...concisely.
If null then this works..

xpath(outputs('XMLRegulations'),concat('//Array[ID/text()="', item()['ID'],'"]/EndDate/text()'))?[0]

Just not sure how to wrap this.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

HamidBee 932 Super User 2024 Season 1 on at

Like (1)

Report
You can use the "coalesce()" function to set a default value if the xpath expression returns null. The syntax would be:

coalesce(formatDateTime(xpath(outputs('XMLRegulations'),concat('//Array[ID/text()="', item()['ID'],'"]/EndDate/text()'))?[0],'d','en-US'),'default value')

This will format the date if it exists, otherwise it will return 'default value'.

You could also use the "default()" function, which can accept default value with the same way.

default(xpath(outputs('XMLRegulations'),concat('//Array[ID/text()="', item()['ID'],'"]/EndDate/text()'))?[0],'default value')

If my reply helped you, please give a 👍, & if it solved your issue, please 👍& Accept it as the Solution to help other community members find it more.

Was this reply helpful? Yes No
sasrsc 678 on at

Like (0)

Report

Thank you. I will try this and report back. One thing I did learn that addProperty by default won't add a null to the JSON but a "select" action will which is interesting. That helps.

Was this reply helpful? Yes No