Hi @v-xida-msft..
When you say "configuration" ... What do you mean?
The main gallery is hooked up to a SQL view which filters for records where a "Date > GetDate()" and results in about 1,000 rows ... however there are additional filters added to the conditions based on drop down selections for "record type"... There is no "Non-delagated query" alert, so everything looks like its done server-side.
So the "Items" property is something like...
SortByColumns(
Filter('[dbo].[CurrentData]',
(Status = ddlStatus.Selected.Value) && (
(
StartsWith(ddlListType.Selected.Value, "Spotlight")
&&
Spotlight
)
||
(
StartsWith(ddlListType.Selected.Value, "Corporate")
&&
Corporate
)
||
(
StartsWith(ddlListType.Selected.Value, "Gov")
&&
Government
)
)), "Date", Ascending, "Account", Ascending, "Name", Ascending)On each gallery item, a few key fields are shown Name, Date, Account, RecordType but there is a "full display" details record that can be viewed by clicking an appropriate button. There is also a drop down for Status and you can choose from "New", "Processing", "Actioned"
When the drop-down is changed, the record is "Patched" using the ID of the item directly to the underying table of the view and the, as you have stated, the data set is then Refresh'ed
Now, using a few tricks, the following metrics have been recorded (approx values)
- Initial display from app launch takes about 3 seconds
- When the status drop down is changed, the underlying record is updated in about 2 seconds
- The following Refresh takes about 3 seconds
- The re-display of the gallery then takes another 30-60 seconds... unless you manually scroll the grid.
NB: The code above has been modified to remove sensitive information and is not a direct copy of the view code.. so may have "errors" but the concept is representitive of the actual implementation.
W/R/T to link to "improving performance", I did see this when first looking for a solution to my problem but none of issues appear to be relevant in this case, but I am a novice at Power Apps (but an experienced developer)...
