Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio - Calling Actions from Copilot S... / PVA Flow to detect emp...
Copilot Studio - Calling Actions from Copilot S...
Answered

PVA Flow to detect empty cell in excel is evaluating false

(0) ShareShare
ReportReport
Posted on by kgreen8790 189

I have an inventory flow that is initiated by my PVA Chatbot and returns values to the PVA Chatbot to check for inventory where there is currently no value in a specified column. The issue I'm having is that both ways I've tried to have the flow evaluate cell data has failed. I've tried to check condition of column "Contract_Num" is equal to "null" but condition evaluates to false for all 19 entries even though 2 of them should be returning true. I've also tried to check condition where column "Contract_Num" is equal to the expression "empty(items('Apply_to_each')?['ExcelField'])" but again all instances evaluate to false when 2 should be evaluating to true. Is there an explanation to this? Is there another way to achieve this that I haven't discovered? Please see screenshots for additional info.

Spreadsheet being referencedSpreadsheet being referenceddebug2.PNGdebug3.PNGdebug4.PNGdebug5.PNGdebug6.PNG

Categories:
Power Automate Flows
Flow Integration
  • Verified answer
    Pstork1 Profile Picture
    Pstork1 67,043 Most Valuable Professional on at
    Re: PVA Flow to detect empty cell in excel is evaluating false

    The output is still an array that needs to be processed to turn it into a formatted string for return.  The point is that its a smaller array that needs to be processed than the one you are processing now.  So it should still be a bit faster.

  • kgreen8790 Profile Picture
    kgreen8790 189 on at
    Re: PVA Flow to detect empty cell in excel is evaluating false

    Yes, that does seem to speed things up on the flow. I noticed when I append it to my string variable that gets returned to PVA it includes a lot of curly braces and square brackets that I don’t get when I do it using the other method. Any idea why it’s displaying these using filter array?

  • Pstork1 Profile Picture
    Pstork1 67,043 Most Valuable Professional on at
    Re: PVA Flow to detect empty cell in excel is evaluating false

    There is an advantage to using filter array, because then you don't have to compare the value on every row. You can get a subset of rows that meet your condition without doing extra actions.

  • kgreen8790 Profile Picture
    kgreen8790 189 on at
    Re: PVA Flow to detect empty cell in excel is evaluating false

    Your solution is valid. I did end up achieving it by simply checking the condition against "contains" "string(0)" and this worked as well. Thank you for your swift response.

  • Verified answer
    Pstork1 Profile Picture
    Pstork1 67,043 Most Valuable Professional on at
    Re: PVA Flow to detect empty cell in excel is evaluating false

    Instead of using a condition try using a filter array on the output of the list rows where that column is equal to null, or you may have to check against and empty string.  The length() of the filtered output is the number of rows with null values in that field.  The resulting array will be the rows with empty cells.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 169 Super User 2025 Season 1

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 150

#3
sandeep_angara Profile Picture

sandeep_angara 75

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans