web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps Canvas - The...
Power Apps
Unanswered

Powerapps Canvas - The right side of the equal operator must be a constant value error.

(0) ShareShare
ReportReport
Posted on by 39

Hello,

 

I'm receiving this error from datasource while trying to filter a gallery through a combo box and lookup fields.

 

First I'm filtering the TCMWOD lookupcolumn/relation so the Workout log is filtered by Workout secondly when i try to further filter it with a TCMUSER which is also a lookupcolumn/relation im receiving the following error.

i have already tried switching places of entities like placing TCMUSER on the right/left side of the equal operation. 

 

for now i can either filter it with username or the workout i want to be able to do both. nested filter is also not working.

 

Saadssk94_1-1643967145745.png

 

 

 

I have the same question (0)
  • Ram Prakash Duraisamy Profile Picture
    5,593 Super User 2025 Season 2 on at

    Hello @Saadssk94 

     

    Hope you are doing good.

     

    Try Changing this Line From 

     

    ComboBox2_1.Selected.'TCM-WOD' = 'WOD(L)'.'TCM-WOD'

     

    to

     

    'WOD(L)'.'TCM-WOD' = ComboBox2_1.Selected.'TCM-WOD' 

     

    Please mark as Answer if it is helpful and provide Kudos


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

  • Saadssk94 Profile Picture
    39 on at

    already tried this. didn't work. 😞

  • Ram Prakash Duraisamy Profile Picture
    5,593 Super User 2025 Season 2 on at

    Hello @Saadssk94 

     

    I think you are comparing with GUID, if so try passing GUID like below

     

    'WOD(L)'.'TCM-WOD' = GUID(ComboBox2_1.Selected.'TCM-WOD' )

     

    Please mark as Answer if it is helpful and provide Kudos


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

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard