Answered

Delays populating a form & indefinite "Getting your data" timeout

(1) Share

Report

Posted on by Madumi

171

I have a large entity, holding 30,000 records. I am using the Search function in a gallery to allow users to search this using text found in the middle of strings. From this gallery, users can select individual records, which then (using the filter function) populate a second gallery from a second entity, usually resulting in 1-6 entries. The (self) selected record in this gallery populates a form containing this selected record.

My first issue arises when a user selects an entry from the initial gallery. At this point, both the second gallery as well as the form *usually* self-populate. However, occasionally, the gallery displays the message "Getting your data," but never completes. The user has to manually select the second gallery, at which point the form populates correctly.

My second issue is that data seems to take a while to enter & be returned from the database once a record has been edited. Eg. when an edit has been submitted on the form, it seems to process & then seems to fail (it doesn't display as submitted)... Except that if the user waits a while and then refreshes both the initial gallery & then the second gallery, the data is correctly displayed.

I'm not sure how much each issue is related, but is there a way to navigate both issues, to reliably refresh updated data in a gallery & form?

Thanks!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Madumi

A few questions:

Do you get a Yellow Triangle warning? (i.e. the query is not being delegated)
Do you already currently use the PowerApps Refresh function to attempt to mitigate this?
Do you already currently use PowerApps Timers to attempt to mitigate this?
If you can disclose it, what is the data source / Connector you are using? Is it Common Data Service Connector or another data source? If it is another data source or Connector, is it a Microsoft Connector or is it a 3rd party connector?
Are both Galleries on the same screen or are they on separate screens?
Madumi 171 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much@poweractivate for the follow-up questions. Sorry for the ambiguity in my Q.:
1) No, there's no delegation happening & no triangle warning.
2) I'm new to powerapps & was hoping for something like a refresh function. Would you at all be able to point me to sample code?
3) No timers involved. I'm unsure how long the interval would need to be. I'm seeing what seems like up to 10 seconds delay before data is inputted & retrieved (i.e. time spent clicking out of the selected record in the initial gallery & back in to see if data displays yet). Most of the time it's only <1 second.
4) It's all Common Data Service, so no database connector problems... though that said, I'm using all custom entities/fields.
5) yes, both the galleries & form are on the same screen. I'm guessing that's the source of the problem, but I'm hoping for a work around. If the filter function could filter based on text in the middle of a string (eg. so "exa" would retrieve "alexander"), I would try that instead of the search function (I believe filter passes the load to the data source, instead of the app).
Again, any hints are hugely appreciated,
thx!
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Madumi ,

Firstly, let me answer you the question about filter.

"If the filter function could filter based on text in the middle of a string.....?"

Yes, it is possible. You just need to use "in" in the function.

For example:

1）Filter(table, Textinput1.Text in fieldname)

2)LookUp (table, Textinput1.Text in fieldname)

3)Search(table, Textinput1.Text , "fieldname")

All these three kinds of formulas could filter the records with the text in the middle of a string.

Here's a doc about these three functions for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Secondly, about your app's performance.

Do you mean that your app could display data and update data correctly. But the app just has delay problem.

Please add Refresh function in the formulas that not work very well, which could help.

For example:

SubmitForm(Form1);Refresh(data source name)

What's more, the app's not performing good may be caused by many reasons, like too large data source, too complex formulas, ect. There 's no very good simple way to solve this. You need to refer some related tips to improve your app in many ways.

Here are some tips about how to improve your app's performance for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/performance-tips

https://powerapps.microsoft.com/en-us/blog/performance-considerations-with-powerapps/

Best regards,
Madumi 171 on at

Like
a
(1)

Report
Copy link

Link copied!

Awesome, thank you so very much.

I tried changing the gallery search function to a filter function, but performance didn't improve. But when I included Refresh(data source name), it seems to have fixed the problem.
poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Yes @Madumi the Refresh function was exactly what we were pointing to, although we also asked some other questions since the actual resolution would have depended on your specific scenario. Glad you were able to use Refresh function to your advantage 🙂