Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Experimental Features
Unanswered

Delegation issue in Data

(0) ShareShare
ReportReport
Posted on by 4
  Hi Community,
 I am working on a power app in which the datasource is a dynamic dataverse table. Here, data is updating daily and it is reflecting in the power app.  So, I have a dropdown box Year in which I can see 2024. But in datasource, I can see entries for 2025 as well, But it is not reflecting in the dropdown. 

I have given logic using distinct query, collections and tried multiple ways, but still I am not getting the year 2025 in the dropdown. But when I apply filter with the year 2025 seperately in a Gallery, I can see the entries
How to avoid this delegation issue? 
 
 
 
  • msoenmez Profile Picture
    46 on at
    Delegation issue in Data
    Distinct function is unfortunately not delegable. In PoweApps it is hard to get around  this limitation.
     
    You need to find a workaround for that - e.g. run a Power Automate Flow over the Dataverse Table and get all unique items and return them to the PowerApps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics