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

Update SP List Multi Select Person from Power Automate using the Update Item SP Connector

Hey guys, I have a SP list item that I'd like to update in my flow. The list has a required field of a multi-person select list of approvers, so the Update Item looks as follows:

 

UpdateItem.PNG

 

SPApprovers looks like this:

Approvers.PNG

And the error is as follows:

Error.PNG

The value of SPApprovers is also taken as the direct output of the Get Item SP list connector, so the flow works as follows:

 

Get Updated information from Azure -> Get SP List Item based on Id -> Update SP List Item

 

So I would expect the format of SPApprovers to be in the exact format that 'Update Item' is expecting. It also doesn't make sense that the error is stating that the DisplayName of the first approver is read-only.

 

Any help would be greatly appreciated. thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @OwninJoe ,

 

I have made a test on my side and couldn't find a way to update the multiple person type column with custom variable, I'm afraid that the function is not supported in Microsoft flow currently.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
CFernandes
Super User
Super User

Hi @OwninJoe , Can you add a Compose Action and check if the SPApprovers returns a String in Power Automate(please post a screenshot of the Compose action)?

 

If it returns we will need a create an array and then pass into the Approvers Field.

Here's the input and output of the compose action:

Compose.PNG

 

Hi @OwninJoe ,

 

I have made a test on my side and couldn't find a way to update the multiple person type column with custom variable, I'm afraid that the function is not supported in Microsoft flow currently.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @OwninJoe.

 

I agree with @v-alzhan-msft I could not find an easy solution or a workaround for your problem.

 

CFernandes
Super User
Super User

Hi @OwninJoe, Did you manage to resolve this problem. I have found an article which might assist you,

 

Have a look at the article https://www.c-sharpcorner.com/article/update-multi-values-people-picker-field-in-power-automatemicro...

 

I hope this helps.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Kudoed Authors
Users online (3,345)