web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / The 'from' property va...
Power Automate
Answered

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

(1) ShareShare
ReportReport
Posted on by 611

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

Categories:
I have the same question (0)
  • Verified answer
    tom_riha Profile Picture
    10,185 Most Valuable Professional on at

    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.

  • Uzi Profile Picture
    17 on at

    Yes it works! 👍

    Uzi_0-1631623489308.png

     

  • jnovelliere Profile Picture
    35 on at

    Nicely done @tom_riha. Solved my issue as well 👍

  • Cyns Profile Picture
    15 on at

    Hello ! Old post but i want to say you exactly resolved my problem

    Thanks a lot !

  • dataserendipity Profile Picture
    3 on at

    Thank you for the solution! It helped me too.

  • GioCubillos Profile Picture
    3 on at

    eres un crack, a mi también me funciono

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard