web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps databinding ...
Power Apps
Unanswered

Powerapps databinding question

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I'm confused as to how databinding really works. I have a powerapp that uses a sql azure database (database diagram attached). On one screen i show the user all the 'Events'  for a  'Group' that the user selected. On another screen I  show all the 'Events' 'Room' that the user selected

 

I expect all tables to have way more than 500 rows,

 

So if a user goes to the screen that  shows the 'Events'  for a  'Group', I expect powerapps to fetch the first 500 rows where the GroupId equals the selected Group.  If the user navigates to a screen  that shows all the 'Events' for a 'Room' that the user has selected I expect where the  RoomId equals the selected Room.

 

In such a case what would the Refresh(Event) function do?

Does each control get it's own copy of the data returned from a datasource based on its filter criteria? If so, does the refresh function refresh all those copies?

 

I think I am missing a key concept here.Capture.PNG

Categories:
I have the same question (0)
  • v-micsh-msft Profile Picture
    Microsoft Employee on at

    The below is the document for the Refresh() function:

    Quoted:

    "

    The Refresh function retrieves a fresh copy of a data source. You'll see changes that other users made.

    "

    So the formula: Refresh(Event) would get a new copy of the Event table, in such a situation, all the fitlers which involved the Event table would be updated.

     

    Basically all the controls would work with the local copy of the Data Source, unless a refresh is executed, which is mostly depending on the function used with the property of the control.

     

    Besides, regarding delegation, see:

    PowerApps Data row limit for non-delegable queries

    Now you could control the local record limit to 2000 through:

    PowerApps Experimental features section (File > App Settings > Experimental features.)

     

    Regards,

    Michael

  • v-micsh-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    Do you have any further questions on this topic?

     

    Regards,

    Michael

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard