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)
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.
Thanks!
Solved! Go to Solution.
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.
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.
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.
User | Count |
---|---|
102 | |
38 | |
31 | |
24 | |
16 |
User | Count |
---|---|
132 | |
53 | |
52 | |
37 | |
26 |