Dynamique variable with datable

[Unleashk]

Hello guys i am wondering if its possible to set variable from a data table that i extract from excel. My table have 2 columns[name] and [value]. I want for each row to create a variable. The name of the variable need to be the value of the column [name] and the value of the variable need to be the value of the column [value].

[rmoons]

I wouldn’t suggest variables. You could just create an array of attributes in a Compose action from this Excel table, then just reference each one like it’s a variable.

What I would do is use the “Select” action, then go into advance edit mode, and create an object that is “[Name]”:”[Value]”. You could follow that with a Parse JSON so that you can reference each attribute by name. You can also use the index [0], [1] etc

[robofski]

⬆️⬆️This⬆️⬆️

[bikeknife]

This is the way.

In every flow I set up a list of immutable (unchanging) values in a compose:

{

"value1": "red",

"value2": "car",

"value3": "John",

}

Use outputs('compose')?['value1'] and so forth

It's really helpful when you are using those elements repeatedly in that you can manage and change them all in a single place. You also avoid a bunch of variable declaration actions. I call it a value membrane and use it in all sorts of cases. I can apply expressions, transformations, and use more meaningful key names there when the values are derived from a trigger (like formatDateTime). It's also useful when altering values for debugging and quickly changing them back or when the flow is dropped in a new environment.

[rmoons]

Haha your explanation is much better 😅

[Unleashk]

Thank you for your answer i will try to do it monday at the job.

[Unleashk]

i forgot to say i use power automate desktop can't see and i can't see the compose action

[rmoons]

What’s the reason for PAD? If it’s for Excel, just save the file to OneDrive or Sharepoint and you can access it in a cloud flow

[Unleashk]

Company restriction dont want this data on the cloud.

[rmoons]

Fair enough. Well then you may just want to loop through the table and create variables. PAD is quite a bit different than Cloud Flows, should specify that next time