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

429

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.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Himanshu Kamboj 429 on at

Like (0)

Report
Copy link

Link copied!

Hi Li,

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

I have written the expression same as you suggested.

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No