Unanswered

Powerapps databinding question

(0) Share

Report

Posted on by Community Power Pla... 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Do you have any further questions on this topic?

Regards,

Michael

Was this reply helpful? Yes No