Answered

Filtering a combobox using a dataverse table's text field

(1) Share

Report

Posted on by twhite

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!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
twhite 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you, worked like a charm!

Was this reply helpful? Yes No