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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I am trying to get mul...
Power Automate
Answered

I am trying to get multiple arrays into one SharePoint column list. I included an image with the error I am getting below for reference...

(0) ShareShare
ReportReport
Posted on by 21

I have a multiple choice question/answer that branches into other multiple choice answers. I have created arrays for each of the multiple choice answer but when I add more than one array into the create item textbox it gives me the error below. The first array works and runs fine but when I add the second array I get the following message.

 

 

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_item': The parameter with value '"@{variables('ComputerIT')}@{variables('BusinessArray')}"' in path 'item/Department' with type/format 'String' is not convertible to type/format 'Array'.'.

SM E1.PNG
Categories:
I have the same question (0)
  • Verified answer
    lbendlin Profile Picture
    8,716 Super User 2026 Season 1 on at

    that error message does not seem to correlate with your problem statement.  Can you please provide a more detailed explanation of what you are trying to achieve and where you are stuck?

  • Mike_2 Profile Picture
    21 on at

    Good Morning,

     

    I have a multiple choice question that branches into other multiple choice answers based on what was selected. In essence, I need multiple arrays that will bring all of those answers into one SharePoint column list. The first branching array works, but once I add more than one set of array's, it gives me that error. Hope this makes sense, and I appreciate your assistance.

  • Mike_2 Profile Picture
    21 on at
    Consultation error.PNG
  • lbendlin Profile Picture
    8,716 Super User 2026 Season 1 on at

    I don't think that field accepts collections of arrays.  Can you transform these into a single array?

  • Mike_2 Profile Picture
    21 on at

    I did try appending them but got an error.

    I did see where my SharePoint column list if it is formatted to multiple lines I would be able to input multiple arrays but my list is formatted currently to  "choice" because we are trying to get the data highlighted in color once they submit the form.

     

    How would I transform them into a single array?

  • Verified answer
    lbendlin Profile Picture
    8,716 Super User 2026 Season 1 on at

    a "Choice"  field is a list.  You would need to transform your two arrays to create a list (ie an array with just one column and no meta data)  before trying to write that back.

  • Mike_2 Profile Picture
    21 on at

    I will search on how to do that, still new and learning but I appreciate all your help.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 460

#2
Vish WR Profile Picture

Vish WR 343

#3
David_MA Profile Picture

David_MA 249 Super User 2026 Season 1

Last 30 days Overall leaderboard