You’re offline. This is a read only version of the page.
10
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.
"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").
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.
@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:
Share
Report
All responses (
Answers (
Distinct(
Filter(
'Your List',
'fault parent'.Value = Dropdown1.Selected.Value
),
'fault child'.Value
)
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
