Skip to main content

Notifications

Power Automate - General Discussion
Answered

Dynamically checking if there is a null array value

(0) ShareShare
ReportReport
Posted on by 20

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.

Boynogs123_0-1644994954505.png

 

Thank you and best regards,

 

Boynogs123,

 

  • Bruno Lucas Profile Picture
    Bruno Lucas 8 on at
    Re: Dynamically checking if there is a null array value

    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 :

    BrunoLucas_1-1645003122312.png

     

     

    But to pick if a random field is empty you will need to loop and test like this 

     

    BrunoLucas_0-1645003014689.png

     

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 31,081 on at
    Re: Dynamically checking if there is a null array value

    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))

     

    xpath_empty.png

     

    Test should look something like this:

     

    outputxpath_empty.png

     

    Kudos to @Paulie78 for this approach. He showed me this back in August last year. Xpath can be very useful sometimes 😁

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard