Answered

Distinct + Filter for datacard

(0) Share

Report

Posted on by EG-31080115-0

118

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.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Thanks,
Stalin - Learn To Illuminate
Verified answer

EG-31080115-0 118 on at

Like
a
(0)

Report
Copy link

Link copied!

I was overcomplicating the solution which is:
Lookup('SP List',ColumnA=ColumnA_drpdwn.Selected.Result,ColumnB)