Copying multiple display names (person field) to text field within the same sharepoint list

(0) Share

Report

Posted on by Sja855

Hello

Is there a way to copy the Names from Multi people picker field to text field with in same SharePoint list?

Appreciate if anyone can help me!

Thanks in Advance!

Categories:

General topics

I have the same question (0)

All responses (11)

Answers (2)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Sja855 ,

Do you want to copy the names of people in multiple selected people columns to other text columns in the same list?
I have a test for your reference.

Best Regards,
Dezhi

Was this reply helpful? Yes No
Sja855 61 on at

Like (0)

Report

Hello @v-dezhili-msft

Thanks for your response. But the ouput is coming in the format of {"name1", "name2"}. How to avoid these unwanted characters and updates only name1, name2 in the field.

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Sja855 ,

In my test my Name column is a single-line text column, they are Name1, Name2, Name3,. . . . This format arrangement does not appear {}.
Could you please show a screenshot of your flow and what it looks like after the data is stored in SharePoint?

Best Regards,
Dezhi

Was this reply helpful? Yes No
Sja855 61 on at

Like (0)

Report

Hello
If you look at the output in the above screenshot, it is getting saved in the same format in List column as well. How to get rid of these special characters?

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Sja855 ,

Can I check your select action?

Best Regards,
Dezhi

Was this reply helpful? Yes No
Sja855 61 on at

Like (0)

Report

Hello @v-dezhili-msft ,

Sure. please find the attached screenshot below and help me out.

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Sja855 ,

Please click where I circled.
Then put item()?['DisplayName'] in it.

Best Regards,
Dezhi

Was this reply helpful? Yes No
Sja855 61 on at

Like (0)

Report

Hello @v-dezhili-msft

I believe it is already updated same as you mentioned. Please find the attached screenshot. Do I need to delete the existing one and replace with the formula that you have mentioned?

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @Sja855 ,

Delete them first, and then only need item ()? ['DisplayName'].
like this:

Best Regards,
Dezhi

Was this reply helpful? Yes No
Verified answer

Sja855 61 on at

Like (0)

Report

Hello @v-dezhili-msft

Worked. Thanks for the great help!

Was this reply helpful? Yes No