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 / Problem with filter da...
Power Apps
Unanswered

Problem with filter data by date

(0) ShareShare
ReportReport
Posted on by 29

Hello guys!

Matiss_0-1633937769082.png

My datasource is dataverse, and i need to filter data by two dates, from date and to date. 

I got an error "The left side of the 'Equal' operator must be a property of the entity"

 

How to do this? 

I have the same question (0)
  • Verified answer
    Ram Prakash Duraisamy Profile Picture
    5,580 Super User 2025 Season 2 on at

    Hello @Matiss,

     

    You are very close to it.

     

    Try Changing from 

     

    Filter(InventerizacijasID;Datumsno<Now() && Datumslidz>Now() && Atrasanasvieta.Text =Strukrura.Nosaukms)

     

    to

     

    Filter(InventerizacijasID;Datumsno<Now() && Datumslidz>Now() && Strukrura.Nosaukms = Atrasanasvieta.Text)

     

    Field name should be in left Operator

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • Matiss Profile Picture
    29 on at

    Okey, now it Filter data, but it still showing the same error : 

    Matiss_0-1633939283859.png

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

  • Ram Prakash Duraisamy Profile Picture
    5,580 Super User 2025 Season 2 on at

    Hi @Matiss,

     

    Hope Datumsno and Datumslidz is a field in InventerizacijasID table am i correct?

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • Matiss Profile Picture
    29 on at

    Yes, Datumsno and Datumslidz is date field in InventerizacijasID table in Dataverse

  • Ram Prakash Duraisamy Profile Picture
    5,580 Super User 2025 Season 2 on at

    Hello @Matiss

     

    How about Strukrura.Nosaukms this one?

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

     

     

  • Matiss Profile Picture
    29 on at

    That is a lookup field in Dataverse table inventerizacijasid

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 774 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 335 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 248

Last 30 days Overall leaderboard