Share
Report
49I have an app created where I am doing a distinct lookup between two columns and then between three columns for a New Form.
It all seems to work but when i publish it, i get these errors.
There are no blank fields in my datasets.
The first option in the dataset for each dropdown is "All"
There are two datasets.
- One for the ProjectName & Corresponding ProjectNumber
- One for the Service, SubService and Type
Here is the error I get.
All three of these fields are dropdown fields that are feeding another dropdown in a cascade.
I used the "Depends on..." option for each Item.
Example1: the dropdown called DDProjectName.Selected.Result will feed the dropdown DDProjectNumber.Selected.Result
Example2: The dropdown DDService.Selected.Result is feeding the dropdown DDSubService.Selected.Result which is then feeding the DDType.Selected.Result
Items Details
Project Name: ForAll(SortByColumns(Distinct(Table1,ProjectName),"Value"), {Result: ThisRecord.Value})
Project Number: ForAll(Filter(Table1, ProjectName = DDProjectName.Selected.Result), {Result: ThisRecord.ProjectNumber})
Service: ForAll(Distinct(Service,Service),{Result: ThisRecord.Value})
SubService: ForAll(Distinct(Filter(Service,Service = DDService.Selected.Result),SubService),{Result: ThisRecord.Value})
Type: ForAll(Filter(Service,SubService = DDSubService.Selected.Result),{Result: ThisRecord.Type})
The data ACTUALLY does filter correctly, however when my users open the App, these three errors pop up and it isn't exactly showing an aesthetically pleasing form...
I am fairly new to Power Apps (Just taught myself a few days ago) and usually i can work my way to an answer, but this one has me stumped. There are no Null values in my datasets...
Based on what is giving me an error, I think it has to do with how I set up my cascading dropdowns for these two datasets.
All responses (
Answers (
