web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Cancelling an approval...
Power Automate
Answered

Cancelling an approval is blank but not null?

(0) ShareShare
ReportReport
Posted on by ABureaux

Hello,

 

I am trying to account for canceled requests in my flows.

 

I did three tests with two people (edited order to match picture):

1. One approve, one reject

2. One approve, one cancel

3. Both approve

 

On the left is the result of my Flow's logic. On the right is the approval's Outcome

ABureaux_0-1637682963599.png

 

Scenarios #1 and #3 seem to work fine. It is when an approval is canceled that things seem to be not working?

 

I originally thought that a canceled request would contain "Cancel", but that is not the case. Then I thought it was just NULL, but that appears to also not be the case:

ABureaux_1-1637683126248.png

 

Any ideas?

 

Categories:
Building flows
I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 68,898 Most Valuable Professional on at

    If the Approval is set to all must approve and the second person cancels, then it isn't approved because the second person didn't approve it.  So Outcome is left blank.  One other thing to notice is that if the first person rejects then outcome will be just "reject".  It won't wait for the second person.

     

    Normally, I use the logic of Outcome contains "Reject" for Rejected.  Then a second layer of Outcome is equal to blank to get Cancelled.

  • ABureaux Profile Picture
    ABureaux on at

    The "Approve" and "Reject" outcomes are easy as the responses actually contain "Approve" or "Reject" in some combination (depending on how many people are on the approval, the type of approval, and the order in which they respond).

     

    Canceling an Approval causes this undesired behavior though (the "Status" column should read "Canceled", not "Approved", but the Flow logic isn't working. EDIT: "Hidden_Status" is still the Outcome of the Approval):

    ABureaux_0-1637685798367.png

     

    And here is my flow. Compared to my above post, the only change is I made is the logic for the nested "Canceled" Condition is now empty (formerly "NULL"). I also zoomed out so you can see that it is nested, with the first layer being a test for "Reject". Sounds similar to your set-up:

    ABureaux_1-1637685880022.png

     

     

  • Verified answer
    Pstork1 Profile Picture
    Pstork1 68,898 Most Valuable Professional on at

    In my tests that logic works fine.  But your condition is backwards. When the outcome is equal to Blank then the approval has been cancelled.  In yours blank outcome leads to approved. 

     

    One other thing to point out.  Only the flow maker has the ability to cancel the approval.  Regular users must either approve, reject or re-assign.  They don't get the option to cancel the approval.

  • ABureaux Profile Picture
    ABureaux on at

    Derp. You are correct. In my last test, I got my logic backwards. So, in summary for those doing approvals:

     

    Approval OutcomeDynamic ContentLogical Operator(1)Value

    Approved

    		Outcomecontain or is equal to Approve
    RejectedOutcomecontains Reject
    Canceled(2)Outcomeis equal to
    		 

     (1) When testing an item between Approved and Rejected, you want "contains" and not "is equal to" if there are more than one person on the approval

     (2) With the value for "Canceled" being blank, not the NULL expression.

     

    I am still a little unclear on how the NULL expression and a blank cell are different, but this seems to be working, so I am happy. Thank you!

  • Pstork1 Profile Picture
    Pstork1 68,898 Most Valuable Professional on at

    Just a reminder that in general you don't really need to worry about Cancelled.  Only the Maker of the flow has access to Cancelling the Approval.  Regular approvers don't

     

    To clarify the difference between null and blank is the difference between null and "".  This is a common problem for Data base developers.  Some DBs handle null and an empty string as the same.  Some do not.  For Power Automate they are definitely not the same.  Null means the value doesn't exist.  An empty string exists, but its length is zero.

  • ABureaux Profile Picture
    ABureaux on at

    Good to know that is how Power Automate handles these values, thank you.

     

    In the case of this approval flow, I dynamically specify the creator of the approval. The owner of the approval may be an approver, but not necessarily. In either case, they have the power/authority to cancel an approval if something goes "wrong". So, while it is definitely in the minority of our approval process, it is something that I would like to properly account for.

    To give you an example: Just today, I had someone mention that one of their approvers went on mat leave without responding to the approval first. In this case, canceling and resubmitting with different approvers made the most sense. Again, this is a very fringe case.

  • Pstork1 Profile Picture
    Pstork1 68,898 Most Valuable Professional on at

    Agreed,  Just wanted to make sure you were aware that it was a fringe case.

  • wskinnermctc Profile Picture
    wskinnermctc 6,519 Moderator on at

    Thank you for that extra note! I would've been trying to accomodate Cancelled requests thinking other people could cancel them.

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
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 307 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 269 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 115 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans