Filter a dropdown from a SP and getting results from the same list dynamically

(0) Share

Report

Posted on by caslasgee

223

Hi All,

I have a SP list as shown below;

List1			
Title	Objective	ObjectiveGroup	DeptID
Item1	Objective1	Objective GroupA	1
Item2	Objective1	Objective GroupB	1
Item3	Objective1	Objective GroupB	2
Item4	Objective2	Objective GroupC	2

I have added a form to capture the above information to a separate list called List2

List2		
Title	SelectedObjective	SelectedObjectiveGroup

In the form, I added a Dropdown (drp1) in a DataCard and populated the Item field to show distinct Objective Column using the following Code:

Distinct(Filter(List1,DeptID = varRecord.ID),Objective)

(The varRecord is another table with the department information)

It shows shows Objective 1 and Objective 2.

I cant seem to get the second dropdown to display the Distinctive Objectivegroup based on drp1.

I tried

Filter(List1,ObjectiveGroup = Drp1.Selected.Result)

But no luck.

Any help please.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @caslasgee ,

Firstly, the output of Distinct is now .Value, not .Result, however you are also comparing the ObjectiveGroup, not the Objective field, so for a start, a record match would be

Filter( List1, Objective = Drp1.Selected.Value )

If you want the Distinct values of ObjectiveGroup

Distinct( Filter( List1, Objective = Drp1.Selected.Value ), ObjectiveGroup )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
caslasgee 223 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz . It worked just fine.

Was this reply helpful? Yes No