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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,070)