Hello,
I have 2 lists, an 'active' and 'archive' list. I want to try to setup a flow to run daily to transfer all active items from beyond a specific date to the archive list. I kept running into issues where I had 3 different choice columns that allowed for multiple selections pulling the incorrect choices. 2 of the 3 are pulling all the choices from the 3rd column instead of what their choices reflect in the SP list.
I had this issue in the past, so I changed the 3 multi select choice fields to multiline text fields since this was just for an archive and not to be used actively. When I setup my flow, everything was going smoothly until it came to passing those array variables. The first way I setup the flow copied the first record's array into all of the records. So I put the append string variables within my apply to each on the create item step. This caused ALL of the array variables to enter into a single record.
I had to put my append into 2 apply to each so I could get the SP column Value to appear in the append value field.
What am I doing wrong?
The top Apply to Each houses ALL append to strings/create item. The output it is taking is the output from get items.
End of flow


Report
All responses (
Answers (