You’re offline. This is a read only version of the page.
289
Hi Guys,
I have two dropdown lists on my form, dd_Level1 and dd_Level2
I have a hierarchy of data and I am trying to create two dropdown lists. The first one selects all distinct values from column HierarchyLevel1, the second selects distinct values from column HierarchyLevel2 where HierarchyLevel1=dd_Level1
Here is the Items property for dd_Level1
Share
ReportSort(Distinct([@PowerBIIntegration].Data,hierarchylevel1),Result)
Here is the Items property for dd_Level2
Sort(Distinct(Filter([@PowerBIIntegration].Data,hierarchylevel1=dd_Level1.Selected.Result),hierarchylevel2),Result)
My problem is that dd_Level2 only returns 2 values (one of which is a blank value) and it should be returning about 12 different values.
As you can see I am integrating my app within PowerBI
My form looks like this:
Please help 😃
Hi Guys, In the end I worked out that it was the distinct function that was preventing delegation. I had to copy the first level (distinct values) of the hierarchy into a separate list, this allowed me to select all of the values on dropdown 1, then I was able to filter the level 2 values based on the level 1 dropdown.
Thank you @KvB1 ,
I believe this is the issue, the Level1 items that appear before POW (alphabetical order) have a complete list of Level2 values available, the data is getting cut off in POW somewhere which explains why values are missing. There is another Level1 value (TEM) which is also missing.
Instead of pulling through all of my data and then filtering it, I think I need to apply the filter to the Power BI data model and only return the data I need. Is this possible?
Hi,
Your filters are looking good. The reason you use .Result instead of .Value, is because the items in your dropdown are the result of the Distinct value.
The row limit indicates how many rows are able to be retrieved by PowerApps in a single query. The default value is 500, so if your filter query would return 501 records, only the first 500 are retrieved to powerapps. You can set this to a maximum of 2000 in the settings in your app.
However, this would assume that the first 500 records of your filter only contain a blank or POWAP for the column you are showing, that seems unlikely. My suggestion would be to troubleshoot, try to test parts of your filter function. For example, you could replace the filter phrase from dropdown.result to just hardcoding something to test whether using the dropdown as a filter is causing the issue.
I used Shane Young's video to get this far, I notice in order to filter on the previous dropdown he uses Selected.Value, but Value isn't available to me which is why I used Selected.Result. I'm not even sure if this is what the issue is
Hi @JimJim ,
You are missing something,No worries you can watch this video to resolve your issue.
Request you to please like and subscribe this video
#1
WarrenBelz
146,658
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
All responses (
Answers (
