PowerApps - sharepoint customized form - filtered dropdown list based on look up

[nolanpa2]

I have two sharepoint lists:

First list <active members> has two columns -

- Group members :  Single Text column

- Active : Yes or No column

Second list <activity metrics>

- would like to do a lookup somehow to pull only those active members into a dropdown list

Would like to customize my sharepoint form for <activity metrics> only to show the active members in the dropdown pick list.  I've already created a rather neat custom form for this list with checkboxes and disappearing areas based on the checkboxes but I cannot figure out how to make this issue with the dropdown list resolve.

Is this at all possible?

It's also important that even when the members are "inactivated" in the original list that the data for them in <activity metrics> is not list.

[NandiniBhagya20]

Hi @nolanpa2 ,
You can add a dropdown and Set items property of it to below formula -

Distinct(Filter(FirstListName,YesNoColumnColumn=true),TitleColumnName)

[nolanpa2]

Hi @NandiniBhagya20 

Thanks for your reply,

in the <active member> list I have added a 3rd column which will consolidate the name and active status by the following calculation

=IF([Currently Active]=TRUE,Associate,"")

This column shows the group member name only if active and blank otherwise

This information is the basis for the dropdown in the 2nd activity metric and when using the sharepoint standard form to input works perfectly - ignoring the blank entries and only the active members appear in the dropdown.

However it is this column data which doesn't react in the same way once the form is being customized in powerapps - it pulls the active members and blank entries in the dropdown for all those which are listed as non-active.

This is the part I would like to eliminate in the custom form and filter out these "blank" entries

[NandiniBhagya20]

HI @nolanpa2 ,

You can try using below formula -

Filter(SPListName, !IsBlank(CalcColumnNew)).CalcColumnNew

CalcColumnNew is the 3rd column in active members list where some calculation is done

[nolanpa2]

@NandiniBhagya20 

Hi @NandiniBhagya20 ,

The datacard for the lookupcolumn in powerapps  looks like this 

Choices([@activitymetrics].activeagrouplookup)

I tried to wrap a filter around it by

Filter(([@activitymetrics].activeagrouplookup).activeagrouplookup) - doesn't seem to work

[NandiniBhagya20 · Accepted solution]

HI @nolanpa2 ,
Try using below formula - 
Filter(Choices([@activitymetrics].activeagrouplookup), !IsBlank(Value))

[nolanpa2]

Awesome!!!! Thank you so much, it works!!