Convert Get Item Output to Array

(1) Share

Report

Posted on by nathankidd

Is there any way to convert the output from SharePoint Get Item from an object to an array? I want to include the data as a table in an email. The only way I can find to do that is to use the Create HTML Table action, but that requires an array. Anyone know how to do that - or have another idea how to get the data from a single SharePoint item into a table to be sent in an email?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (1)

Report

Hi

Add a Select action, to pick the columns you want in the order you want, also add column headers and add that to the Create HTML.

The below is an example, but on the input put your Body/Value output of Get Items.

For the Columns, add whatever Strings you want for the Column Header (on the left)

in the right side, put in the dynamic properties, or you have to type item()?['Column Name'] on the right.

Type item()?[''] in the expression tab, not directly into the input box or it will just see text, not the expression.

Was this reply helpful? Yes No
nathankidd 16 on at

Like (0)

Report

Thanks but unfortunately that does not fix my problem. The Select action is also looking for an Array. Since I am using Get Item (not Get Items), i don't have an array.

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Initialize an array variable and then Append the object to the Array. Use the Array to create your HTML Table.

Was this reply helpful? Yes No