cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
afernandezUY
New Member

filter on filtered choices

Hi All, 

I have a lookup field and I´m trying to filter by one column property.

With this function I got duplicated records (same line have the column Form set to "Secondary" and "Primary". 

Filter(Choices(Secondary.Account),Value in Filter([@Accounts],Form = "Secondary").'Account name')

 The main list is Secondary and Accounts is the list from where I get the items to show and filter.

 

How I can filter the results? 

 

thank you guys!!

 

2 REPLIES 2
v-monli-msft
Community Support
Community Support

Hi @afernandezUY ,

 

What is your data source and related columns' data types?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Mona

I have a "Secondary" Sharepoint List from where I created a custom form to add records.

The column "Accounts Names" is a lookup field from other list "Accounts", in this dropdown I need to filter only the values that contains the String "Secondary" at the Form column.

The problem is thata the query is showing duplicates

 

Find attached some screeshots to see it better.

 

Regards

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,342)