Input Entire array when creating sharepoint item

(1) Share

Report

Posted on by RobS1308

Hello There,

I hope someone can help me.

The general idea of my flow is this: I want to use MS Forms to create Items for a Sharepoint list, which will store "Items" with parameters that eventually I want to pull into an App in Power Apps and use filter options to filter through the list to find the right items.

This Sharepoint list will not have more than 500 lines, wont even get to 100.

After struggling with my biggest problem: The multiple Choice field and how to store it in the Sharepoint list, so that I can filter each choice seperately within power apps, I found this article: https://365basics.com/microsoft-flow-populate-a-multi-choice-field-in-sharepoint/

(Each "Item" in this list will have different subtypes the power app should be able to search for....it should make it easier to find the right items. A parametric search, but there isnt always only ONE parameter, but multiple).

I was able to do all steps of it BUT the last crucial one: Sending the "entire array" to the sharepoint list. I do not get this Option as explained in the last step.

I tried to figure out if it has something to do with how the list field is configured. Its currently set as "multiple lines of text". "Choice", didnt give me the option either.

What I also found strange, in comparison to all the help threads here, my "Sharepoint Connector Icon" is green, not blue:

Basic flow:

And it works up to "Create Item". In there is no option to select the Array nor to change the input to "input entire array".

Here should be "SubtypeArray" as a choice. Its not there.

Anyway, my overall problem is the format to save a multiple choice input from a form into a database which then can be used in power apps as a product/item finder by parameters.

I would gladly appreciate anyone who can point me into the right direction.

Would "Collections" help me here in Power Apps? Or would it only give me the "loading Speed" Advantage for my Application?

Thanks,

Rob

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Dear Rob,

I'm wondering if you managed to solve this issue.

I'm in a very similar situation, I need to copy an array from one MS List to another and I can't use the "switch to input entire array" option that everyone is referring to in MS Flow.

Any ideas would be highly appreciated.

Was this reply helpful? Yes No
RobS1308 7 on at

Like (0)

Report
Copy link

Link copied!

So there is a workaround that I used now.
I have put all the Data in a Multiple Lines of Text type of field. Then in Powerapps I split those up and take out the [" , "] and seperate the values and put them into Collections. This works in the end quite well. For the List I leave it as is.

["Value1","Value2","ValueX"]
I replace and seperate the Values so that I have a collection which has each Value in a seperate field and then use that with the "Distinct" function to show each Value only once in a field.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RobS1308 , thanks so much for your quick response. I really appreciate you jumping back in to a very old post.

Unfortunately I can't follow your explanation... it goes beyond my current level in Flow, but the good news is that after reading your message and a bit more testing, I managed to enable the "switch to input entire array" option. It wasn't appearing until I selected "allow multiple choices" on the list column settings.

The issue is that even when that option is on, the flow is not giving me the result I expect, as this is what I get when I copy the whole array into the list:

ArrayName:
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"XYZ"}]

I have no idea how to get rid of the whole thing and only get XYZ which is what I need to copy from List A to List B.

😒

Was this reply helpful? Yes No