Gallery: refresh one or few records only ?

(0) Share

Report

Posted on by FLOWPA

Within a gallery, the only refresh function is Refresh(datasource).

This seems a waste of resources, when there is only one or few records that I'd like to refresh.

If my gallery is filtered to show only 5 records, and I use the Refresh(datasource) function, is the function going to refresh only the gallery displayed 5 records? Or it's going to refresh the entire datasource?

Any more efficient solution?

(I found this older post, but there were no answers with a solution.)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@FLOWPA
Is there a particular reason you are refreshing the data source??

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

It will definitely refresh the entire data source each time you call that function. But as @RandyHayes said is there a specific reason you are refreshing the data source?

Was this reply helpful? Yes No
FLOWPA 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes wrote:
@FLOWPA
Is there a particular reason you are refreshing the data source??

@RandyHayes @Pstork1

In this case, the data source is a Google spreadsheet.

www.contoso.com > Google spreadsheet > PowerApps app

We have a website (external to PowerApps) that submits data into the spreadsheet. When a new row is added into the spreadsheet, PowerApps doesn't seem to be aware of the new row of data, that's when we refresh the app. Refreshing the whole data source, for 1 or few new appended rows doesn't seem efficient.

I keep reading about users experiencing gallery performance issues. Refreshing the whole data source could be part of the problem. I don't have performance issues, because I make sure the gallery is built efficiently with filters and formulas.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

In your case there is no alternative other than refreshing the entire dataset. Making sure you are using appropriate filters with delegable functions to retrieve the minimum required records will help. But you will have to refresh the whole data source. It has no way to know which records have been added and which are old other than comparing what it already has in memory. That comparison would be more time consuming than refreshing the full data source.

Was this reply helpful? Yes No
MikeyMole 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I also have this exact same want - I use Stored Procs a lot to change the datasources and refresh is overkill.

I have posted an idea on this point so maybe upvote if you want it to get noticed 🙂

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Targeted-Refresh-Function/idi-p/1531560

Was this reply helpful? Yes No
srx_nstratton 76 on at

Like
a
(0)

Report
Copy link

Link copied!

I have a plugin that synchronously refreshes similar rows in my dataset. Be nice to only update the relevant rows.

Was this reply helpful? Yes No