Announcements
Hello guys!
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?
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/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
Okey, now it Filter data, but it still showing the same error :
The left side of the 'Equal' operator must be a property of the entity
Hi @Matiss,
Hope Datumsno and Datumslidz is a field in InventerizacijasID table am i correct?
Yes, Datumsno and Datumslidz is date field in InventerizacijasID table in Dataverse
Hello @Matiss
How about Strukrura.Nosaukms this one?
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 103
WarrenBelz 82 Most Valuable Professional
wolenberg_ 67 Super User 2026 Season 1
