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

Flow to populate SPO list Person type column

I am creating a flow and want to auto-populate Reviewers column with Reviewers (users' email addresses) that user enters when they manually start the flow.  This works when a user enter 1 reviewer, but this fails with the below error message if a user enters multiple reviewers.  Any idea how to get this column populated with multi reviewers? 

"status": 400,

  "message": "The specified user XXXXG@XXXXX.OnMicrosoft.com;XXXX@XXXXX.onmicrosoft.com could not be found.\r\nclientRequestId: c5b7f06b-95e2-413a-96db-73c8bbdd3127\r\nserviceRequestId: c5b7f06b-95e2-413a-96db-73c8bbdd3127"

SPRock76_2-1597330407062.png

 

 

1 REPLY 1
manuelstgomes
Super User
Super User

Hi @SPRock76 

 

The field you're trying to insert expects one entry (email) at a time. You can do it dynamically, but you need to format the date as follows:

[
  {
    "Claims": "email 1"
  },
  {
    "Claims": "email 2"
  }
]

 

Here's the view when you fill in manually.

Screenshot 2020-08-14 at 12.54.50.png

 

Press the button:

Screenshot_2020-08-14_at_12_54_50.png

 

And here's when you "Switch to input the entire array." 

Screenshot 2020-08-14 at 12.54.54.png

 

I wrote an article explaining this issue that is common with Microsoft Forms that can show you the problems and the necessary formulas to convert the data:

https://manueltgomes.com/microsoft/powerautomate/multi-select-form-sharepoint/

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,967)