2 choices columns - one works and other not - same type column in Sharepoint List - Why ???

(0) Share

Report

Posted on by ferby2023

Hello all,

first, thanks for helping!

So, I have 2 choices columns in my sharepoint list.

When I use 1 column to test, it works perfectly. but when I user the other, it is not filtering!

I checked everything, I debug, filtered data in SP to compare.

The only difference between this columns, is that one has the "REQUIRED" check and the other (which is not working) does not have.

Is that a problem?

Here is the formula:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

TuongDoan 573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try Status.Value = "Active" instead of Status = "Active"

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!

Was this reply helpful? Yes No
ferby2023 45 on at

Like (0)

Report
Copy link

Link copied!

So, if I change this Status, the formulas turns to error. It wont allow me to do this change. But, even though there is a delegation warning, this filter is working perfectly by filtering only active!

Was this reply helpful? Yes No
TuongDoan 573 Moderator on at

Like (0)

Report
Copy link

Link copied!

So, where is the not working part? I see only 1 red underline in the picture

Was this reply helpful? Yes No
ferby2023 45 on at

Like (0)

Report
Copy link

Link copied!

the ccb_50 (combobox)
when I pick up a value in this combobox, it is not filtering!
All other columns works perfectly, I tested.
But for some reason, this columns is not working. And the difference of this column to other is that this column does not have the "REQUIRED" in sharepoint list. But they are exactly the same.

Was this reply helpful? Yes No