Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 45

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:

ferby2023_0-1716479754926.png

 

  • ferby2023 Profile Picture
    ferby2023 45 on at
    Re: 2 choices columns - one works and other not - same type column in Sharepoint List - Why ???

    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. 

  • TuongDoan Profile Picture
    TuongDoan 550 on at
    Re: 2 choices columns - one works and other not - same type column in Sharepoint List - Why ???

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

  • ferby2023 Profile Picture
    ferby2023 45 on at
    Re: 2 choices columns - one works and other not - same type column in Sharepoint List - Why ???

    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! 

  • TuongDoan Profile Picture
    TuongDoan 550 on at
    Re: 2 choices columns - one works and other not - same type column in Sharepoint List - Why ???

    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!

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard