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

(0) Share

Report

Posted on by wonka1234

920 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:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
ThxAlot 22 on at

Like (1)

Report
Copy link

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

Was this reply helpful? Yes No