Customer experience | Sales, Customer Insights,...

How to get the element's dynamically from any appended array in power Automate?

(0) Share

Report

Posted on by Himanshu Kamboj

389

Hi,

I have a MS flow , Where I need to store the elements in an array and later on, I need to use this array to create the HTML table.

So for that I am appending the elements in an array and it's getting successfully appended, but after that as I am creating the HTML table using this appended array then flow giving the error /The property 'columns' must be specified unless the 'from' property value is an array of objects./

To overcome from this error I am trying to structure these array elements through the select property of /Data Operations/, but I am not getting a way to extract these elements from the /appended array/.

can you please suggest the way, how can I retrieve the elements from the array dynamically??

Below: I am trying to format the data through select operation

Now I just Need to know the expression to get the values from the appended Array.

All responses (3)

Answers (0)

Dengliang Li Microsoft Employee on at

Like (0)

Report

How to get the element's dynamically from any appended array in power Automate?

Hi,

The following are the modified expressions.

json(variables('MyArray')?[0])?[0]?['Program Name']
json(variables('MyArray')?[0])?[1]?['Entity Type']
json(variables('MyArray')?[0])?[2]?['Entity Name']
json(variables('MyArray')?[0])?[3]?['Document Type']
json(variables('MyArray')?[0])?[4]?['Uploaded On']

I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.

Best Regards,
Dengliang Li
Himanshu Kamboj 389 on at

Like (0)

Report

How to get the element's dynamically from any appended array in power Automate?

Hi Li,

I have tried it but it's giving the error.

I have written the expression same as you suggested.
Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

How to get the element's dynamically from any appended array in power Automate?

Hi,

Based on the information you provided, a similar MS flow was created for testing.
The expression used in the Select action is as follows.
json(variables('MyArray')?[0])?['Program Name']
json(variables('MyArray')?[1])?['Entity Type']
json(variables('MyArray')?[2])?['Entity Name']
json(variables('MyArray')?[3])?['Document Type']

I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.

Best Regards,
Dengliang Li