Hello,
Firstable, Thx a lot for your help :-)
1/ Build a Flow named test with Power Fx activated
2/ Create flow as requested ... and it works ... Strange
TEXT => LOOP FOREACH OF_VALUE IN $fx'=OF_66_CSV'
3/ Same approach in the main Flow, Issue already presents
I've deleted and rebuild the FOR EACH LOOP and it works ...
The solution is amazing but some bugs remains :-)
I've translated this flow from environement without Fx to an environnement with Fx (For Active Directory needs)
I think this is the root cause.
After some research, I've found the correct syntax to retrieve Fx variable in SQL transaction.
SET QUOTED_IDENTIFIER OFF
insert into OpenFlyers (
[id],
[name],
[first_name],
[last_name],
[email],
[cell_phone]
)
values (
"${ReadCell(OF_VALUE,1)}",
"${ReadCell(OF_VALUE,2)}",
"${ReadCell(OF_VALUE,3)}",
"${ReadCell(OF_VALUE,4)}",
"${ReadCell(OF_VALUE,5)}",
"${ReadCell(OF_VALUE,6)}"
)
So Thanks again for your help.
Christophe
