web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Trouble passing Array Variables from one SP list to another

(0) ShareShare
ReportReport
Posted on by 174

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.

NathanFra_0-1634730762725.png

 

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?

NathanFra_1-1634730790456.png

The top Apply to Each houses ALL append to strings/create item. The output it is taking is the output from get items.

NathanFra_3-1634730893975.png

NathanFra_4-1634731076293.png

NathanFra_5-1634731096929.png

End of flow

 

 

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 797 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
developerAJ Profile Picture

developerAJ 319

Last 30 days Overall leaderboard