Forum Discussion
Solved
Trying to avoid formula:firewall error using python script
Hi Guys, i have the code like here: = fnGetPath("BUNDLES_PATH_TEST") - this is my function with argument refrencing to windows environment. Function is: let
GetPath = (envVariable a...
jaryszek , Try using
let
GetPath = (envVariable as text) =>
let
Source = Python.Execute("
import os
import pandas as pdenv_value = os.getenv('" & envVariable & "')
data = [[env_value]]
df = pd.DataFrame(data, columns=['Path'])
"),
df1 = Source{[Name="df"]}[Value],
Path = df1[Path]
in
Path
in
GetPath
jaryszek , Try using
let
GetPath = (envVariable as text) =>
let
Source = Python.Execute("
import os
import pandas as pd
env_value = os.getenv('" & envVariable & "')
data = [[env_value]]
df = pd.DataFrame(data, columns=['Path'])
"),
df1 = Source{[Name="df"]}[Value],
Path = df1[Path]
in
Path
in
GetPath
It worked! thanks.
Unfortunately still formula:firewall error is there...
Best,
Jacek