cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pstudart
Helper I
Helper I

Create List Item MultiValue Person or Group Fails

When I leave the Approvers and Distribution Fields Empty the create item works.

When I set Approvers and Distribution from get file properties it does not work, When I hit the array button it reveals alot more types of selections for the multivalue person or group fields. I tried to use claims but that also fails. What should I be using in these scenarios?

 

create item question.png

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @pstudart 

 

Thanks for the screen share. The fix we did is constructed the array format of people or group as follows by iterating the approvers from file properties.

 

[

{

"Claims": "test1@test.com"

},

{

"Claims": "test2@test.com"

},

{

"Claims": "test3@test.com"

}

]

 

Finally under the create item select the 'T' sign (convert to array) and placed the dynamic mapping of the above array values.

 

Hope the session was useful.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

14 REPLIES 14
abm
Super User
Super User

Hi @pstudart 

 

You can use email to update the person or group column types.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

Hi @pstudart 

 

If you have multiple person or group then use the following 

 

[
{
"Claims": "1234@test.com"
},
{
"Claims": "abcd@test.com"
}
]



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

When I switch the columns to array and add the Approvers email and distribution email I get the error message about about nest loops.

 

Unable to save.png

abm
Super User
Super User

Hi @pstudart 

 

Could you please explain why you have two apply to each loops?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

When I select Approvers Email and Distribution email property it auto adds a apply to each loop. I didn't do it myself.

Hi @pstudart 

 

Remove both apply to each loop. Declare an array (two) and store the values for Approvers and Distribution. Then add the update item and set each array for approvers and distribution.

 

Thanks 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

I put the approver and distribution fields into array variables and put them in the create item and i am getting this error message.

 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation does not allow writing a value for parameter 'item/Approvers[0]/DisplayName'. This parameter is read only.

 

fails on create item.png

abm
Super User
Super User

Hi @pstudart 

 

Please have a look at my YouTube video 

 

https://www.youtube.com/watch?v=5MeJCcdgm0k&t=52s

 

Let me know if you need further help.

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Thanks for the Video but I doesn't hit on what I'm trying to do.

 

I have List A and List B they share the same content type and have a multi person or group field called approvers.

 

I run a flow on list A that creates a record in list B

When I create the item in list B I want to set the approvers field in list B to the the approvers values from list A.

 

Thanks for taking the time to help me.

 

abm
Super User
Super User

Hi @pstudart 

 

Are you updating the person or group column by email address?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Ya, that doesn't work. also for each multi person or group field I set it adds another apply to each. I am currently trying to run a update item after I run the create item in order to set the multi person or group fields.

Hi @pstudart 

 

If you ok for a screen share I could quickly look this and find a solution for you.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

Hi @pstudart 

 

Thanks for the screen share. The fix we did is constructed the array format of people or group as follows by iterating the approvers from file properties.

 

[

{

"Claims": "test1@test.com"

},

{

"Claims": "test2@test.com"

},

{

"Claims": "test3@test.com"

}

]

 

Finally under the create item select the 'T' sign (convert to array) and placed the dynamic mapping of the above array values.

 

Hope the session was useful.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Thanks so much for your time it was really useful. Heres a step by step of what you showed me.

 

 

Initialize a Variable
Name : person or group field
Type: Array
Value: blank

Next-----------------------

Compose
input:
{
"Claims":Field Email
}

Next-----------------

Append to array variable
Name : Approvers
Value: output

 

now you can use that variable were you need the person or group set.

 

 

 

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 (4,967)