Creating Item from a Person to a Multi Text Field is showing up as "odata.type.."

(0) Share

Report

Posted on by wonka1234

909 Super User 2024 Season 1

Hi,

When I am creating an Item from List A into List B , The output is like "[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|tag0335@gmail.com","DisplayName":"Stevens, Louis","Email":"Louis.Stevens@gmail.com.com","Picture":"UserPhoto.aspx?Size=L&AccountName=Louis.Stevens@gmail.com.com","Department":"Cool Department","JobTitle":"Cool guy"}]

How can I convert this field to not show this?

Thanks.

Categories:

Business Process Flows

All responses (3)

Answers (0)

ThxAlot 22 on at

Like (1)

Report
Re: Creating Item from a Person to a Multi Text Field is showing up as "odata.type.."

join(xpath(xml(json(concat('{"root":',coalesce(item()?['PersonsTest'],'""'),'}'))),'/root/DisplayName/text()'),';')
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Creating Item from a Person to a Multi Text Field is showing up as "odata.type.."

@v-yueyun-msft looks to be working with some fields, but others I am getting error -

Unable to process template language expressions in action 'Review_Converted' inputs at line '0' and column '0': 'The template language function 'json' parameter is not valid. The provided value '{"root":{"item":}}' cannot be parsed: 'Unexpected character encountered while parsing value: }. Path 'root.item', line 1, position 16.'. Please see https://aka.ms/logicexpressions#json for usage details.'.

Looks to me this error occurs when there is a blank in a row. Otherwise this formula works fine.
v-yueyun-msft on at

Like (1)

Report

Re: Creating Item from a Person to a Multi Text Field is showing up as "odata.type.."

Hi , @wonka1234

This is my SharePoint List and the output of the "Get items" action in flow.

For example , if you want to extract the [DisplayName] of this Person, You need to use expression to get:

join(xpath( xml(json(concat('{"root":{"item":',item()?['PersonsTest'],'}}'))) , '/root/item/DisplayName/text()')
,';')

join(xpath( xml(json(concat('{"root":{"item":',item()?['Internal Column Name'],'}}'))) , '/root/item/DisplayName/text()')
,';')

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