cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JB0007
Helper V
Helper V

Filter Dataverse with PowerApps display error

Hi Power Apps community,

 

I want to filter my list based on the expression below, but I get the error of "The left side of the equal operator must be a property of the entity. 

But as you can see I have all my dataverse columns at the left side of the operator.

 

Round(CountRows(Filter(Project_Tasks,Project_ID=lblThisProjectID_1.Text && Task_Status="Completed").ID) / CountRows(Filter(Project_Tasks,Project_ID=ThisItem.ID ).ID) * 100,1) &""&"%"

 

Can someone please help me?

1 ACCEPTED SOLUTION

Accepted Solutions
rampprakash
Super User
Super User

Hello @JB0007 

 

Try with this first

 

Round(CountRows(Filter(Project_Tasks,Project_ID=lblThisProjectID_1.Text && Task_Status="Completed").ID) /1))

 

And see weather its working or not, so that we can identify which place we are getting this error.

 

As per my knowledge all the operators are in left side only

 

Please mark as Answer if it is helpful and provide Kudos


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

View solution in original post

2 REPLIES 2
rampprakash
Super User
Super User

Hello @JB0007 

 

Try with this first

 

Round(CountRows(Filter(Project_Tasks,Project_ID=lblThisProjectID_1.Text && Task_Status="Completed").ID) /1))

 

And see weather its working or not, so that we can identify which place we are getting this error.

 

As per my knowledge all the operators are in left side only

 

Please mark as Answer if it is helpful and provide Kudos


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

Prakash4691
Super User
Super User

Hi @JB0007 ,

Could you please tell me where are you using this expression. Which control and property?

Round function will return only decimal numbers.

 

 

Regards,

Prakash

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,578)