PowerApps is integrated with PowerBI. There are 221 unique values in a column of power bi table.
I am using Sort(Distinct([@PowerBIIntegration].Data, ColumnName),Result) in drop down in powerapps - But, only shows 21 records that are chosen random.
How can i allow dropdown to show all 221 values?
Hi @spartanboy ,
How many records in total you have in [@PowerBIIntegration]? I'm guessing that you are hitting the delegation limit because distinct function is not delegable. Can't you try to filter the table prior the distinct?
I have a multiple columns in a table with 3000+ records in it = [@PowerBIIntegration].Data. But, 'Column_1' has distinct 220 items.
If I use Sort(Distinct([@PowerBIIntegration].Data, Column_1),Result) - then it show all 221 items right?
No. Distinct is not delegable so you will se the values which are captured up till the delegation limit
(e.g. if your app's delegation limit is 500 rows, it will give you the distinct values of your column based on the 1st 500 records it finds.)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.