cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cgreenmzr
Helper I
Helper I

SharePoint List Items to Select or HTML Table

I want to create a flow that gets a list item when it's created, map and/or format the list items so I can pass all of the fields into an HTTP POST. Is this possible? I'm trying the flow below and keep getting "The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array.". Any thoughts? Thanks in advance!

cgreenmzr_0-1646885229380.png

 

2 REPLIES 2
tom_riha
Super User
Super User

Hello @cgreenmzr ,

the 'Select' action expects an array as the input = multiple items in this case, but you've got just a single item. If it's a single item you can build the object directly in the 'Compose' action.

{
"Key1": "Value1",
"Key2": "Value2",
...
}

 



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
cgreenmzr
Helper I
Helper I

Thanks @tom_riha ! You pointed me the right direction with using the 'Compose' action. I think my answer was even simpler than that what you provided. 

cgreenmzr_0-1646920833631.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,288)