Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 774 Most Valuable Professional
Michael E. Gernaey 335 Super User 2025 Season 2
Power Platform 1919 248
