Answered

Named formula used as collection

(0) Share

Report

Posted on by Jitendra_FT

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

ivan_apps 2,187 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jitendra_FT 72 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

ivan_apps 2,187 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Jitendra_FT 72 on at

Like (0)

Report

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.

Was this reply helpful? Yes No