You’re offline. This is a read only version of the page.
6
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?
Never mind. The colours was missing in my Sharepoint list. When I added them back it worked. Again thank you very much @Expiscornovus
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.
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.
Share
Report
All responses (
Answers (
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
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
