cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microbes
Resolver I
Resolver I

Distinct + Filter for datacard

I have a form. Datacard1 contains dropdown of values from SP list column A which I used Distinct function to populate.  For Datacard2 I want to reference the selected value from Datacard1 to look up value from SP List column B. I've tried:

LookUp(Filter('SP List',ColumnA=ColumnA_drpdwn.Selected.Result),ColumnB)

and

Distinct(Filter('SP List',ColumnA=ColumnA_drpdwn.Selected.Result),ColumnB)

 

Neither worked.

1 ACCEPTED SOLUTION

Accepted Solutions

I was overcomplicating the solution which is:

Lookup('SP List',ColumnA=ColumnA_drpdwn.Selected.Result,ColumnB)

View solution in original post

3 REPLIES 3
StalinPonnusamy
Super User
Super User

Hi @Microbes 

 

Are you trying to set items property of Datacard2 based on Datacard 1 then? try this

 

Sort(Filter('SP List',ColumnA=ColumnA_drpdwn.Selected.Result).ColumnB,ColumnB)

 


Thanks,
Stalin - Learn To Illuminate

StalinPonnusamy
Super User
Super User

Hi @Microbes 

 

 I assumed you are trying to set the Items property of another dropdown based on dropdown 1. Please let me know if that's not the case.

 

StalinPonnusamy_0-1636775520782.png


Thanks,
Stalin - Learn To Illuminate

 

I was overcomplicating the solution which is:

Lookup('SP List',ColumnA=ColumnA_drpdwn.Selected.Result,ColumnB)

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

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 (4,444)