You’re offline. This is a read only version of the page.
45
I 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.
I was able to finally find an answer after three days of searching.
1st. I realized i didnt need the ForAll function in my formulas so i removed them.
2nd, i needed to add a If(IsBlank( to my Item formula so that it would be able to not look for null values in my dataset (that didnt exist).
I need to update the Item = If(IsBlank(DDProjectName.Selected.Value),Table1,Filter(Table1, ProjectName = DDProjectName.Selected.Value))
Basically saying, If the previous dropdown is blank then show the whole table1 data for ProjectNumber, otherwise, filter the ProjectNumber column based on the data listed in the ProjectName Column.
Stay up to date on forum activity by subscribing.
#1
stampcoin
86
#2
DS-11051211-0
20
#3
MS.Ragavendar
9
Share
Report
All responses (
Answers (