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

Report
All responses (
Answers (