Question: colSelectApprove.ID is GUID value. When I am filtering the dropdown in canvas app like this I am facing a runtime error. - Expression expected at

colSelectApprove.ID is GUID value.
When I am filtering the dropdown in canvas app like this I am facing a runtime error.- "Expression expected at position 5 in '(not )and(statecode eq 0)'."
SortByColumns(
Filter(
Signature,
Not('Enamel User'.User in colSelectApprove.ID),
Status = 'Status (Signature)'.Active
),
"lastname",
SortOrder.Ascending
)
What I am doing, I have a checkbox in the gallery which onCheck adds every thisitem GUID to the collection and I want to filter out these guid where I am using this code for dropdown.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!