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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,446)