Why am I getting this warning in my canvas apps?

(0) Share

Report

Posted on by Usman2

124

Hi

In my canvas app's, app checker -> Formulas -> Warning section I am getting this warning.

I am referencing one-to-many relationship to get the ID's of related records and filter gallery. Because we are having performance issues in the app, I am thinking if this is the problem. My question is that does this really effect the app performance and how can I avoid this and get the related record id's without this warning?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

CU30070808-0 on at

Like (0)

Report
Copy link

Link copied!
Can you share more information about the data (number of rows), that you're processing in the app? Are you performing multiple API calls in a single function?

Here are some things you can try
If the data source is Dataverse, consider making views which are only used in the canvas app. The purpose is to limit the amount of rows going into the app from the server side.
Consider this: Are you calling the same data source, on the same screen, for the same requirement? If so, consider loading the data in the screens "OnVisible" property in order to save API calls.
Are there any static reference data in the data source, which you could load into collections on app start, and on the OnVisible property, rather than directly in the required component?

Hope some of this helps. Feel free to share your code, along with some descriptions of your task, and lets have a look at it.

Was this reply helpful? Yes No
Usman2 124 on at

Like (0)

Report
Copy link

Link copied!

Hi @PatrickDamborg

Just to explain, let say I have 2 tables Book and Author and the relationship type between these tables is Many-to-Many. Now I have a gallery (galAuthor) on the left side of screen which list all the records in Author table, and when the user selects any record in another gallery (galBook) on the right side of screen I want to show all of the books this author has written.

I am using this formula to show the Books written by selected author in the items property of galBook:

LookUp(Authors, Author = galAuthor.Selected.Author).Books

And in the items proper of galBook I am getting the warning I mentioned in my post. I hope you get the problem now. Thanks

Was this reply helpful? Yes No
Verified answer

CU30070808-0 on at

Like (1)

Report
Copy link

Link copied!

This makes sense.

The warning in of itself makes sense. In order to avoid this, I would make a third link table, which I would call ‘book release’ in this case, or ‘release’ for a more generic name.

Then I would make an N:1 between ‘book’ and ‘book release’.

Then a N:1 relationship between ‘book release’ and ‘author’.

in dataverse, there exists an invisible linker table called publisher_authorbookset, which is only able to be retrieved through power automate and fetch XML. By creating one yourself, it enables you to reference it in canvas apps, and model driven apps. It also allows for more data points to be stored about the given tables.

Hope it helps!

Was this reply helpful? Yes No