Get items Person Picker Data from one SharePoint List to Another

[Britt1]

Hi everyone 

I'm trying to "Get Items" from list A to list B. Both list A and B include a people picker column titled "Presenter". Without any dynamic content entered into the "Presenter" field of the "Create Item" action, my flow copies the required list items over perfectly. However, when I go to enter dynamic content such as "PresenterClaims" into the "Presenter" field, my flow doesn't work and I get the below error:

TriggerCreate Item without dynamic entered into "Presenter" field.Create Item with dynamic content entered into "Presenter" field.

Any tips would be greatly appreciated! @Rhiassuring 

[vivekpande18]

Hi @Britt1 , 

You don't require Apply to each 2. Directly use create item inside Apply to each. 

Suppose your json is like below which you got from Get Items

[{Data1}, {Data2}, {Data3}]

In Apply to each you are providing above json data as input and in Apply to each 2 

you are providing {Data1} as input. Since Data1 is object and not array. 

This is the reason why you are facing this issue. 

Don't forget to mark this as answer if this solves your problem. This can help others as well. 

[Rhiassuring]

Hi there, 

It looks like Presenter is a multi-select Person field. Is that accurate? 

If this is the case, you will need to ensure - since you are passing from one Multi-Select person column to another - that you use the actual proper title, without any thing after it (like Presenter Email, Presenter Claims, etc -- just "Presenter"). Like so (my column name is ManyPeoples):

If I added "ManyPeoples EMail" it would turn into an apply to each, because it means it's trying to access the Array it holds. These magical columns actually  hold a lot of detail behind the scenes.

Also, make sure that little icon to the right looks like it does above, and not like this:  

Cheers,

Rhia

[Britt1]

Hi @vivekpande18 

The Apply to Each 2 occurs automatically when I insert any dynamic content into the corresponding fields. 

Thanks

Britt

[Britt1]

Hi @Rhiassuring 

Thank you so much for your reply. I tried this as my first option without any luck. The data doesn't come across and the field remains blank. After much too-ing and fro-ing, I implemented the below and it worked!

1. Manually trigger a flow
2. Initialise array variable (array)
3. Get items (from list A)
4. See image 1 attached
5. See image 2 attached

Thanks

BrittImage 1Image 2

[Rhiassuring]

Ah hey! Whatever works! I'm glad you got it going.

[vivekpande18]

Happy to hear that it works!!!

But what is the use of actions in image 1. If you want to just fetch the Presenter Email then you don't require all the actions  mention in image 1, you can simply use Select action to fetch that and that set. 

Also its not advisable to use Apply to each for large number of items. It reduces the efficiency of your flow. 

[Britt1]

Thanks for the tip @vivekpande18  - I'm still learning about all the functions of Power Automate and after watching a few YouTube videos and trying a few different combos, this is what worked. In regards to the Apply Each function, everyone of them bar the first one come up on their own.