
Announcements
Hi, we are currently facing a serious issue with Dataverse access from a canvas app. I have a query to populate a gallery that, when executed by entering a screen, stalls the app (with the dots animation on top) and loads for several minutes or forever. The query seems simple:
Sort(Filter(NG_Prüfpunkte; 'NG_Prüfpunkte (Views)'.Raumscharf; StartsWith(Kategorie.crd27_nummerierung; activeCategory) && 'Legacy ID' in relevantChecks && Raumscharf=JaNein.Ja); Kategorie.crd27_nummerierung&'Legacy ID'; Ascending)
The gallery items contain several objects other objects that read information from other tables based on different variables, for example:
If(lblAnsweredIndicator_1.Text="1";LookUp(NG_AntwortenBenutzers; Prüfpunkt.ID=ThisItem.ID && Raum.crd27_name=dpdRaum_1.Selected.Name).Antwortoption.'Antwort-Option')
There is constant network activity but nothing that would hint at a problem.
I have seen this issue in different environments and with different apps. Also in admin screen I have observed this behavior, such as the app sharing screen where the list of users did not load.
Any ideas or pointers would be highly appreciated.
Best regards
Christian
Little update here, the topic is not yet solved after extensive discussion with the support team. I suppose it is a limitation in the requests to Dataverse.
In the meantime I have completely rewritten my code and am caching everything in collections, which makes it superfast in addition.