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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtering a combobox u...
Power Apps
Answered

Filtering a combobox using a dataverse table's text field

(1) ShareShare
ReportReport
Posted on by 9

i have a combobox that is pulling datat from a dataverse table. I want to filter by 'Active' <> "No" & another combobox.

The other combobox filter is working. 

 

The 'Active' field is defined in dataverse as a text / string value.

 

this code:

Filter(Client_Services_Escalation_Category_1S,ComboBox1_6.Selected.Client_Services_Escalation_LoB='Line of Business'.Client_Services_Escalation_LoB, Active<>"No")

 

Returns:

The requested operation is invalid. Server Response: Client_Services_Escalation_Category_1S failed: The right side of the "Equal" operator must be a constant value.

 

HELP!

I have the same question (0)
  • Verified answer
    365-Assist Profile Picture
    2,324 Moderator on at

    The issue is with the first condition in your filter. Its the wrong way around.

    ComboBox1_6.Selected.Client_Services_Escalation_LoB='Line of Business'.Client_Services_Escalation_LoB

    The source data should be on the left of the = sign.

    'Line of Business'.Client_Services_Escalation_LoB = ComboBox1_6.Selected.Client_Services_Escalation_LoB

    --------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

  • twhite Profile Picture
    9 on at

    Thank you, worked like a charm!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard