cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yoursnani
Post Patron
Post Patron

Need to pull Data only status "active"

Hi 

 

I am customizing share point list . and I am pulling different list data in single drop down . everything OK but I need only status = active data only need to pull . how can I do. Please find my expression 

Screenshot_2021_0511_203508.png

   Thank you 

1 ACCEPTED SOLUTION

Accepted Solutions

@Yoursnani ,

As I mentioned, this function does not always work when you try to put different data sources in a drop-down. You will have to run this somewhere before you need the data 

If(
   DataCard51.Value = "Gas",
   ClearCollect(
      colElements,
      Filter(
         Project WBS Elements',
         Status="Active"
      ).'Active WBS Elements'
   ),
   ClearCollect(
      colElements,
      Filter(
         'Project WBS Elements - Diesel',
         Status="Active"
   ).'Active WBS Elements'
)

and then your dropdown Items will be colElements .

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

5 REPLIES 5
WarrenBelz
Super User
Super User

Hi @Yoursnani ,

Are these two different lists you are using here or are the fields a complex field type of some description?

If(
   DataCard51.Value = "Gas",
   'Project WBS Elements'.'Active WBS Elements',
   'Project WBS Elements - Diesel'.'Active WBS Elements'
)

Also I assume the field name Status is part of the list/s?

Hi @WarrenBelz 

 

Yes both are different list . and different fields but I just made same name column's. But I have status named column's its hold active and inactive . I want active only 

 

Hi @Yoursnani ,

Conditional Items in drop-downs are problematic at times - try this

With(
   {
      wList:
      If(
         DataCard51.Value = "Gas",
         Filter(
            'Project WBS Elements',
            Status="Active"
         ),
         Filter(
            'Project WBS Elements - Diesel',
            Status="Active"
         )
      )
   },
   wList.'Active WBS Elements'
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

@WarrenBelz 

It's not work . getting error "logical test to evaluate for each row. Only the rows that pass this test will included in the results of filter)

@Yoursnani ,

As I mentioned, this function does not always work when you try to put different data sources in a drop-down. You will have to run this somewhere before you need the data 

If(
   DataCard51.Value = "Gas",
   ClearCollect(
      colElements,
      Filter(
         Project WBS Elements',
         Status="Active"
      ).'Active WBS Elements'
   ),
   ClearCollect(
      colElements,
      Filter(
         'Project WBS Elements - Diesel',
         Status="Active"
   ).'Active WBS Elements'
)

and then your dropdown Items will be colElements .

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,306)