Hello!
I have built a flow to get items from one SharePoint list and create copies in another SharePoint list. It is mostly working fine, but columns with multiple choice options will not copy through. For example, I have a multiple choice column called 'Risk Level' where users can either select 'high', 'medium' or 'low'. The options selected in the original list will not copy over to the new list. Does anyone know how to fix this?
Thanks in advance!
Hi @Jacozin
If problem hasn't resolved, then pls give a try.
As it is multiselect choice field, so you need to write an expression to get the values in an array and then pass the array to the multiselect choice field while creating new item.
Pls modify the flow as per below instructions:
Firstly, delete the "Apply to each 3" action.
Next, add "Select" action inside "Apply to each 2" action and write expression as mentioned below:
items('Apply_to_each_2')?['MultiChoiceCol']
Note: Pls replace MultiChoiceCol with actual column name 'Risk level' so for you the above expression will be:
items('Apply_to_each_2')?['Risklevel']
Similarly, write an expression for Map value:
item()?['Value']
Finally, add "Create item" action within "Apply to each 2" action and pass the output of select action to copy multiselect choice field:
If this helps & solves your problem, please remember to give a đź‘Ť and accept my solution as it will help others in the future.
Thanks
As I can now see it's a multi-select field, I tried this again. It doesn't work for me though. When I use the 'select' action and put the 'Risk level' in the 'value' field, it creates another loop and the 'select' function is nested inside it.
Hi,
I tried that and received this message:
"This action cannot be dragged out of foreach as it depends on an action inside foreach."
This is what the flow currently looks like:
Hi @Jacozin
Pls try dragging out Select action from "Apply to each 3" (inner loop) and delete the inner loop once done.
If this helps & solves your problem, please remember to give a đź‘Ť and accept my solution as it will help others in the future.
Thanks
Hello,
Thanks for the response!
I've tried that. I added the 'Select' action before the 'Create Items' action. It keeps creating Apply for Each Loops when I try to do what you suggested. Any ideas on how to fix this?
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,026
Most Valuable Professional
Share
Report
All responses (
Answers (
