Unanswered

Filtering One Sharepoint List Choice by the value in another field.

(2) Share

Report

Posted on by Cryolith

Caveat: I am very new to PowerApps.

I have seen some similar problems reported, but none are exactly what I am trying, and those solutions have not worked for me.

I have a Sharepoint list used to track an item fault. I want to be able to categorize those faults using two choices, one is a broad category, and the second is a more specific callout, based on the first. I want to filter the choices in the second column by what is selected in the first column.

I have tried building separate lists and linking them, and I have tried making choice columns in the same list and cannot get either to work properly.

fault parent	fault child
1	1.B
1	1.C
1	1.D
1	1.E
1	1.F

For clarity - when entering the record, I want the parent column to dictate the choices in the child column, based on a table or list of choices.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Cryolith - assuming both Choice fields have been configured as single-select Choices in your SharePoint list, and assuming your post is about Dropdown/ComboBox controls, you could use the below in the Items property of the "Fault Child" Dropdown control:

Distinct( Filter( 'Your List', 'fault parent'.Value = Dropdown1.Selected.Value ), 'fault child'.Value )

Was this reply helpful? Yes No
Sunil Kumar Pashikanti 2,338 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!

Are you looking the cascading (parent - child) dropdown behavior on SharePoint list, if yes, I don't think it is possible.

You can modify/customize the SharePoint form in PowerApps and achieve this functionality and still users can use the same SharePoint form only.

Was this reply helpful? Yes No
Cryolith 10 on at

Like
a
(1)

Report
Copy link

Link copied!

Still is not working. Am I doing something wrong with the references?
""Distinct(
Filter(
'DefectChildren'',
'DefectParent'.Value = DataCardKey5.Selected.Value
),
'DefectChildren'.Value
)
""

Was this reply helpful? Yes No
Cryolith 10 on at

Like
a
(1)

Report
Copy link

Link copied!

I think that what you are saying is even if I can get the form to work, it still won't function that way in the database list?

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

"Still is not working" is not very specific @Cryolith. It would have helped if you shared what the error message was.

Assuming all of the assumptions I raised in my previous post are correct, and assuming you're using an EditForm control, then above will work.

I do notice in your code that you're referencing a control called "DataCardKey5".

The "DataCardKey" naming convention is always applied to the Label inside the DataCard. What you are supposed to be referencing is that ComboBox control inside that DataCard (it will always start with "DataCardValue" followed by a number (e.g. "DataCardValue1").

Was this reply helpful? Yes No
Cryolith 10 on at

Like
a
(1)

Report
Copy link

Link copied!

Still getting this error. Fixed the reference to the correct DataCardValue, but values still aren't recognized?

Was this reply helpful? Yes No