Answered

Ending up with ["Test1","Test 2"] in Sharepoint List from MS Forms via Power Automate

(0) Share

Report

Posted on by pjallex

Hi,

I have a Form where there are several fields. The first field is called Firmanavn (Company name) and the second field is called **bleep** (Subject). In the second field the users have to choose between the options Test1, Test 2, Test3 and Test4. They can choose more than one. All fields are compulsory. There are more fields after theses two. In this example Firmanavn is Bore AS and I've choosen **bleep** Test1 and Test 2.

This form in then automated over to a Sharepoint List using Power Automate and all fields from the Form is transferred into the corresponding fields in the Sharepoint List fine apart from the fact that the values Test1 and Test 2 is coming as ["Test1","Test 2"] and not as Test1 and Test 2. See picture below.

The record Bore AS 2 is created manually by me in Sharepoint and in the column **bleep** you see how I would like Bore AS also to be displayed.

Does anybody have any idea why it's not showing as I want it to? Am i doing something wrong?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,876 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pjallex,

You can use a Select action to convert the array into an array which can be used in a SharePoint multi-choice field.

Below is an example

1. The From uses the answer of the question and also uses a json function to convert the string to an array.

json(outputs('Get_response_details')?['body/rdd559840fb3c4c7589d6bef0b18866a5'])

2. The Value key is added in the Map field. The current item is used in the Value field

item()

3. The input mode of the your field is switched to entire array, so the output of the Select can be used

Was this reply helpful? Yes No
pjallex 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer and your solution 😀
I should stop using the Norwegian word for subject in this forum I can tell 😂

After some trying and time I managed to make it work. Thanks 👏 (I'm all new to this).

So another question. Is it possible to get this function to use the current colours as it is in my Sharepoint list?

Now Test1 and Test 2 is not coming in in the list in Sharepoint as Test1 (green colour) and Test 2 (blue colour). Just plain Test1 Test 2.

Was this reply helpful? Yes No
pjallex 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Never mind. The colours was missing in my Sharepoint list. When I added them back it worked. Again thank you very much @Expiscornovus

Was this reply helpful? Yes No