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
Community Champion
Community Champion

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
Community Champion
Community Champion

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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,326)