Answered

How to update dynamically a multiple person field?

Like (0) Share

Report

Posted on 3 Jun 2024 11:43:11 by raks

Hello,

I have a flow that loop on different SharePoint list with the same structure. The goal is to update a multiple person field of all these lists basing on another list with the same multiple person field.

I follow this tutorial to update a multi person field: https://www.youtube.com/watch?v=xY97aIsEf6Q but I cannot adapt with dynamic content.

So finally, I have an array like this:

And I pass this array to the item property of the action "Update item" but I have the following error:

Here it is in Edit Mode:

So I want to update my column "Auteur" with the content of the array, the other columns of the list must not be updated.

Can someone tell me what's wrong?

All responses (6)

Answers (1)

raks on 04 Jun 2024 at 06:32:39

Like (0)

Report

Re: How to update dynamically a multiple person field?

Thanks you @v-yueyun-msft

The Site address in in a list, I don't know why it doesn't work if I call it directly from the list. But I put the value in a variable and now, it works.
Verified answer

v-yueyun-msft on 04 Jun 2024 at 06:05:33

Like (0)

Report

Re: How to update dynamically a multiple person field?

Hi, @raks

Thanks for your response! Yes, your json structure is wholly correct. And can you try to use the static value to test if it can work in your side?

Best Regards,

Yueyun Zhang
raks on 04 Jun 2024 at 06:01:34

Like (0)

Report

Re: How to update dynamically a multiple person field?

I don't know this column type- and don't have this. But my person column is the only column that I want to update. For the JSON code, I have exactly the same structure but maybe I will try directly with real values to test instead of variable.
v-yueyun-msft on 04 Jun 2024 at 05:53:31

Like (0)

Report

Re: How to update dynamically a multiple person field?

Hi , @raks

Thanks for your response!Sorry for i haven't note that. Oh , you use the dynamic list in your side.

I test it in my side , it works good like this:

And your error code is this, do you have a column with [dataset]?

Best Regards,

Yueyun Zhang
raks on 04 Jun 2024 at 05:35:09

Like (0)

Report

Re: How to update dynamically a multiple person field?

Hi @v-yueyun-msft,

My column name is "Auteur", not "Item". You don't understand that I work dynamically. The column names are unknown in the process and that's why it's shown Item to pass every updated column of the list in JSON.
v-yueyun-msft on 04 Jun 2024 at 02:17:39

Like (0)

Report

Re: How to update dynamically a multiple person field?

Hi , @raks

If you want to modify the SharePoint multi-select person column, you need to pass this:
[{"Claims":"xxxxxxxxx"},{"Claims":"xxxxxxxxx"}]

Solved: Update a person field in sharePoint with multiple ... - Power Platform Community (microsoft.com)

First, you need to check if your ColumnName is "Item" in your side(In my side , my column Name is "Signers"). And also you can convert to the classic mode to see all the fields.

You can use this expression to get the array.

outputs('Compose')?['Auteur']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang