cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Maharba
New Member

Help With Multi-Person Value Array

Hello there, fine folk of the internet.

 

I've been working on an automation to copy data from one list to another and a couple of the fields that need to be copied are Multi-Person-No-Group fields with varying information (See DAL Mentor field in screenshot below)

Screenshot 2022-08-15 110943.png

 

I have an array set up that SHOULD copy the data from the these fields, but I don't seem to have it set up properly. It is only taking information from the first row's DAL Mentor field and copying that info to EVERY destination's row's DAL Mentor field. Instead of doing a one for one copy of each row. Here's what I have for the array. My gut tells me this is happening because I didn't do a Compose step? But I'm still wrapping my head around all this, so guidance would be appreciated. 

 

Screenshot 2022-08-15 111334.png

 

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @Maharba ,

you can use the 'Select' action directly on the SharePoint field - just select their email addresses and map them to the 'Claims' key.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

3 REPLIES 3
tom_riha
Super User
Super User

Hello @Maharba ,

you can use the 'Select' action directly on the SharePoint field - just select their email addresses and map them to the 'Claims' key.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Thanks Tom! That worked and is a LOT simpler than what the rest of the internet has been telling me! Now I just need to find out why it caps out at 100 rows. I have ~150 to replicate and it only gets 2/3rds through before saying "Completed!"

 

Off I go to learn some more!

Hello @Maharba ,

the 'Get items' action has a default limit on 100 items (even though it lies to you by telling that default = all), just add a higher number in the 'Top Count' field in that action, 5000 is the maximum.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,886)