Hi everyone,
Is there a way to check the array if there is a null value like the picture below?
Dynamically checking if there is a null value.
Thank you and best regards,
Boynogs123,
Hi,
where is this array at? is the input? returning data from a query? or is it from a array variable?
you can test if the entire array is empty, like :
But to pick if a random field is empty you will need to loop and test like this
Hi @Boynogs123,
You could probably use xpath for this with a text function. Convert it first to xml to be able to do this.
Below is an example.
1. Add a Select action. Use the expression below for the From field.
This expression converts the outputs of the compose into xml and finds the nodes which are empty with xpath.
xpath(xml(json(concat('{"Columns":',string(outputs('Compose')), '}'))), '//Columns/*[not(text())]')
2. Switch the Map field to text mode. Use the expression below.
This expression converts the content back into readable column names. You should get an array with column names which are empty.
substring(base64tostring(item()['$content']), 1, sub(indexOf(base64ToString(item()['$content']), '>'),3))
Test should look something like this:
Kudos to @Paulie78 for this approach. He showed me this back in August last year. Xpath can be very useful sometimes 😁