Unanswered

Environment Variable - Using a Web Resource (Javascript) to access the Environment Variable value

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have created an Environment Variable in my Power App Solution and I want to access the value of the variable using the Web API in a Web Resource with JavaScript.

Could this done using XRM in Javascript ?

Thanks

- Rory

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

a33ik 3,306 Most Valuable Professional on at

Like (1)

Report
Hello Rory,
Generally speaking "Environment Variable" is 2 entities in CDS that are available through api.
You should query entities environmentvariabledefinition (to apply the filter by variable name) and environmentvariablevalue to get the value. Generally speaking following FetchXml should bring you what you need:
<fetch> <entity name="environmentvariabledefinition" > <filter> <condition attribute="schemaname" operator="eq" value="test" /> </filter> <link-entity name="environmentvariablevalue" from="environmentvariabledefinitionid" to="environmentvariabledefinitionid" > <attribute name="value" /> </link-entity> </entity> </fetch>

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

An improvement on the above is to make it an outer join and to also return the DefaultValue from the environment definition - then you have the ability to cater for if the environment variable is not set in an environment.

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
As the previous users mentioned, you can. A clean way if you want to avoid fetchXML is with the out-of-the-box client web api script, retrieveRecord.
Xrm.WebApi.retrieveRecord("environmentvariablevalue", <GUID>, "?$select=value").then(successCallback, errorCallback);
Note: the GUID of the environment variable value will be the same in the different environments if you imported the variable with a solution.

More info: https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/xrm-webapi/retrieverecord

Hope this helps!

Was this reply helpful? Yes No