Announcements
Hi,
I have a Canvas application that utilizes Dataverse as a Datasource. I've established named formulas for Lookup and Choice fields with the intention of using them instead of Collections. However, upon monitoring, I've noticed that each time I open a form, the requests for lookup and choice fields go to the server (Dataverse) instead of retrieving from the cache, as it would with collections. Is this the anticipated behavior of named formulas or am I overlooking something.
Appreciate you response.
Yes, named formulas are meant to auto-update when it detects something could have changed its values or a refresh is needed. It saves you from having outdated data cached in the app, and manually having to refresh to get the latest. It actually saves a lot of code writing since you don’t have to track state of cached data, as is the case when you load something OnStart.
Thanks @ivan_apps for your response.
My requirement is, I have 15 lookup columns in a Dataverse table. I want to cache the Lookup column values from master tables as I know Master data won't change during user sessions, but Named formulas are making requests to the same master table(lookup) data each time User opens the form in the same session. I am sure there is no change in master data so it can't trigger auto-update of Named formula.
Is Named Formulas always refresh automatically after 30 seconds even if there are no changes at source?
It shouldn't be every 30 seconds but I can't recall the details. Are you worried about network traffic or are you working on low bandwidth? If not, it should not be an issue for refreshes as it won't affect the user experience.
If you are worried about the network requests or low bandwidth environments, I would store that information into a global variable, either OnStart or on your start screen OnVisible, and don't refresh if that variable is not blank.
Yes, I'm worried about network requests and agree with your suggestion to cache data locally in global variable/collection.
In case you have any reference available, what causes the Named formulas auto-update that would be helpful.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 93 Most Valuable Professional
Haque 81
Valantis 49
