cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TesDA
Responsive Resident
Responsive Resident

The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array.

I'm getting an error that a select needs an array. Is there a way to make the input an array so it works in a select statement. My goal is to create a csv with clean headers - is there another way to do that from the sql Get Row?

 

Error: The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array.

 

Get Row (creates object from row captured) -> Select cleans up column names -> Create CSV table

 

2021-09-03_11-08-33.jpg

2 REPLIES 2
tom_riha
Super User
Super User

Hello @TesDA ,

I don't know if it'll work, but did you try to add opening [ and closing ] around the From input? If you manage to turn the Object into an 1 item Array you should be able to use the 'Select' action.



[ 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. ]

Yes it works! 👍

Uzi_0-1631623489308.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,751)