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

Community site session details

Session Id : MpoimyvCM3UqMdx63HPg/j
Power Automate - Building Flows
Unanswered

The left side of the 'Equal' operator must be a property of the entity.

Like (0) ShareShare
ReportReport
Posted on 5 Jul 2023 10:44:35 by 48

I got an error in data verse

"The left side of the 'Equal' operator must be a property of the entity."

Arnablaha_0-1688553855873.png

 

I have the same question (0)
  • Thami Profile Picture
    on 11 Jan 2024 at 07:54:11
    Re: The left side of the 'Equal' operator must be a property of the entity.

    I experienced the same error when I had a Compose action output on the left and the table column on the right. Swapping the Compose output from left to right and table column from right to left resolved my issue.

  • rzaneti Profile Picture
    4,096 Super User 2025 Season 2 on 05 Jul 2023 at 12:14:03
    Re: The left side of the 'Equal' operator must be a property of the entity.

    Hi @Arnablaha ,

     

    I see that you are trying to list the rows from a Dataverse table, filtering a column from it. The message error means that you have no column called '493500331' in your table. 

     

    Could you please confirm which column you want to filter? In general, the name of the column for filtering purposes is different from the 'Display name' that we see in Dataverse standard view, and in Power Automate you must filter by the 'logical name', which you can find in the Column details from your Datverse Table:

    rzaneti_0-1688558944003.png

     

    Another option to identify the 'logical names' of the columns is to run your 'List rows' action without any filter, access the raw outputs and, by checking the properties names from one of the elements of the body/value, identify the property that returns the desired value. 

     

    To access the raw outputs, you just need to go to the flow run page, navigate until the specific action and click in these buttons:

    rzaneti_1-1688559099467.png

     

     

     

     

    It will open a JSON view in a sidebar or in a new tab:

    rzaneti_2-1688559099870.png

     

     

    Find the "body" property (you can search it with Ctrl+F). Make sure to remove any sensitive content from the image before sharing it here. Also, this article provides additional details about how does these raw inputs/outputs work and how to access them: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 854 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 525 Moderator

#3
trice602 Profile Picture

trice602 318 Super User 2025 Season 2

Last 30 days Overall leaderboard
Loading complete