Answered

Possible to reference an environment variable in Calculated column?

(0) Share

Report

Posted on by Cooper01

664

I have a canvas app and in the OnStart, if there is a parameter passed with a record ID, it will navigate to a screen with a view form, opening that specific record. I'd like to store the URL on the record for a completely separate reason but the app exists in multiple environments, so the app URL changes.

Ideally, I would like to store the app URL as an environment variable and then I could concatenate that with the parameter and record ID to generate the complete link.

Is there any way to get an environment variable value in the context of the Calculated column editor?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Cooper01 ,
Could you tell me:
Do you want to use calculated function in entities? Refer to the picture below
Then do you get the value of the environment variable in this function?

If so, I'm afraid it can't be achieved. Because the two entities ('Environment Variable Definitions' and 'Environment Variable Values') are managed, you cannot use this function.
In other types of entities, although you can use this function, you cannot get the value of the environment variable.

So, I suggest you get environment variables in the app. Then use the concat() function to generate a complete URL from the environment variables and ID.
It is a good choice to write the formula in the onstart property.

If you still have any question, please don’t hesitate to let me know.
Best Regards,
Wearsky

Was this reply helpful? Yes No
Cooper01 664 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response. Marking as solution because my question was answered as this cannot be achieved via calculated column. The calculated column was to be used outside the context of the Power App so unfortunately workaround will not work for this.

Was this reply helpful? Yes No