cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

filter choices

Hi guys,

Can you please correct my function 

I need to filter the choice where Credit Card Usage is my share point list and programStatus is a collection that I have created to collect the active programs.

Thanks in advanced 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @MalekA :

I am not sure what the meaning of this formula is. Could you tell me:

  • Which field of programStatus do you want to filter Value?What is the field's datatype?
  • Do you want to filter the records whose value in the Active field in programStatus is "Active"?
  • What  is 'Active''s datatype?I assume it is 'Text'.

let me explain why this code not work.

It is not allowed to use multiple Comparison operators to connect multiple parameters in one conditional judgment.('A in B = C' is not allowed)

1.JPG

You can try

 

Value = "Active"

 

or

 

Value in ProgramStatus.Active

 

or

 

Value in Filter(ProgramStatus,Active="Active").Active

 

 

Best Regards,

Bof

 

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi @MalekA :

I am not sure what the meaning of this formula is. Could you tell me:

  • Which field of programStatus do you want to filter Value?What is the field's datatype?
  • Do you want to filter the records whose value in the Active field in programStatus is "Active"?
  • What  is 'Active''s datatype?I assume it is 'Text'.

let me explain why this code not work.

It is not allowed to use multiple Comparison operators to connect multiple parameters in one conditional judgment.('A in B = C' is not allowed)

1.JPG

You can try

 

Value = "Active"

 

or

 

Value in ProgramStatus.Active

 

or

 

Value in Filter(ProgramStatus,Active="Active").Active

 

 

Best Regards,

Bof

 

View solution in original post

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (11,448)