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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / DataSetApi.Types.Condi...
Power Apps
Unanswered

DataSetApi.Types.ConditionOperator missing value 13 (NotNull)

(0) ShareShare
ReportReport
Posted on by 1,039

For the type definition of DataSetApi.Types.ConditionOperator in componentframework.d.ts - the list of operators is missing the value 13 for 'NotNull'

 

I'm guessing this is a mistake because using this value correctly filters the dataset.

 

The current definition is:

namespace DataSetApi {
			namespace Types {
				/**
				 * Supported Condition Operator for filtering expression condition
				 * This is subset of full condition operators list defined in https://docs.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.query.conditionoperator
				 */
				type ConditionOperator = -1 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 8 | 12 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 22 | 23
											| 25 | 26 | 27 | 28 | 29 | 33 | 34 | 37 | 38 | 49 | 70 | 75 | 76 | 77 | 78 | 79 | 87;
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @ScottDurow ,

    Could you please share a bit more about your scenario?

     

    Based on the ConditionOperator Enum link that you provided above, I agree with your thought almost. If you would like to get further help on this issue, please consider submit an assisted support ticket through the following link:
    https://powerapps.microsoft.com/en-us/support/pro

     

    Best regards,

  • ScottDurow Profile Picture
    1,039 on at

    I don't think this is enough of a blocker to submit a ticket. I just cast to unknown to access NotNull (13).

     

    The scenario is where I use addFilter and I want to add a 'NotNull' condition. Let me know if there is something else you need to know.

     

    Thanks

  • AnqiChen Profile Picture
    Microsoft Employee on at

    @ScottDurow ,thanks for reporting.

    we have already enabled 'not-null', I guess it's last November in North America area, are u still blocked by this issue?

    BTW, It's not enabled on typing interface so far, but if you use 13, it should work

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 354 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 320

#3
Mohsin Ali Profile Picture

Mohsin Ali 246

Last 30 days Overall leaderboard