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 😁
