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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Kusto query oddness: "...
Power Apps
Unanswered

Kusto query oddness: "Name is not valid. The identifier is not recognized." when changing the "!=" to "=="

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Why does this not work in my OnSelect property?

The error is: "Name is not valid. The identifier is not recognized."

I believe it's complaining about ThisItem.Name.

ClearCollect( ArticleHtmlDiagCollection,
   AzureDataExplorer.listKustoResultsPost(
   "https://***.kusto.windows.net",
   "***",
   "Dim_Customer** | where Id == '" & ThisItem.Name & "'").value);

 

but it does work when I change the equality operator from the == to !=  ?

Categories:
I have the same question (0)
  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Hi @MTv ,

     

    In could please show the error message ?

     

    I hope you tried with = and <>

     

     

  • MTv Profile Picture
    Microsoft Employee on at

    Those are not Kusto (Azure Data Explorer) Query Language comparison operators.

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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard