how come my cascading list doesnt work in Powerapps, but i did it correctly in SharePoint Lists?

If your cascading dropdowns are not working in PowerApps, there are a few things you can check:

1. Data Source Configuration: Ensure that the data source for your dropdowns is correctly configured. If you're using SharePoint lists, confirm that the lists are accessible and that the fields you want to display are set correctly.
2. Display Field: Check the Value property of the dropdown. Make sure it is set to the correct field from your data source that you want to display. If the dropdown is unclickable, it might be due to incorrect settings in the properties.
3. Distinct Function: If your child dropdown contains duplicate items, consider using the Distinct function to filter out duplicates. This can help ensure that only unique values are displayed in the dropdown.
4. LookUp Columns: If you're using LookUp columns in SharePoint, ensure that they are set up correctly and that the data is being pulled as expected.
5. Debugging: Use debug labels to inspect the formulas and ensure that the data is being retrieved correctly. If the dropdown options are empty, verify that the field you are referencing contains data.

If you continue to face issues, it may be helpful to revisit the setup of your dropdowns and ensure that they are configured to respond to the selections made in the parent dropdown.

References:

• Create dependent drop-down lists in a canvas app
• Isolate issues in canvas apps

all of that is working and correct

Dear @Hayes, Evan J K,

Thank you for posting your question in the Microsoft Q&A forum regarding the issue with cascading dropdowns in Power Apps that worked correctly in SharePoint Lists but are not functioning as expected in your app. Below are some key steps and checks to help resolve this. 

To help me narrow down the cause, could you please provide the following details?  

• Are you receiving any error messages when trying to interact with the dropdowns? 
• Can you describe how your lists are set up in SharePoint? 
• Have you customized forms in PowerApps, or are you using the default layout? 
• Is the dropdown field type correctly set as a lookup field in SharePoint? 

In the meantime, please try the following official troubleshooting options which usually resolve issues with basic issues: 

Step 1: Verify data connections 

• Ensure your SharePoint lists are properly connected in Power Apps. 
• Confirm that the correct data sources are being used for each dropdown. 

Step 2: Set cascading logic 

• In Power Apps, cascading dropdowns require filtering based on the parent selection. For example: Filter(Choices([@YourList].YourDropdownField), YourCondition) 

Replace YourList and YourDropdownField with your actual list and field names. 

Step 3: Check field types 

• Confirm that the dropdown fields are correctly configured and that the Primary Text property displays the intended field. 

Step 4: Unlock fields 

• If the dropdown is inside a form, select the data card > go to Advanced > click Unlock. This allows you to edit properties like DisplayMode and Items. 

Step 5: Permissions 

• Verify that your account and the app have sufficient permissions on the SharePoint lists. 

Step 6: Avoid duplicate items 

• If duplicates appear, apply the Distinct() function to the data source:  

Distinct(Filter(YourList, Condition), FieldName)   

For more details, please refer to Microsoft’s official documentation: 

Create a dependent drop-down list in a canvas app - Power Apps | Microsoft Learn 

Customize forms (model-driven apps) - Power Apps | Microsoft Learn 

Please review the above steps and share the requested details. If needed, I can provide exact Power Fx formulas tailored to your SharePoint column types and app design. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.