Filter Dataverse with PowerApps display error

[JB0007]

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?

[rampprakash · Accepted solution]

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]

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