Unanswered

MSList to Excel transfer error for the position "Owner"

(0) Share

Report

Posted on by DanielH1

Hello all,

I have created a fully functional flow in which I regularly filter an MSList according to a certain date range and transfer it to Excel.

However, in my MSList there is also a column in which an Outlook contact is stored.

When transferring this column, I had to write my dynamic content "Owner (Outlook)" in quotation marks in the action "Select" and the field "Card", instead of selecting it without quotation marks like all the others, otherwise my flow fails. (See also image)

But now it shows me all data of this person in the excel, incl. mail, name, position .... - See also the following output:

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|Mailadress","DisplayName":"Name","Email":"Mailadress","Picture":"Userphotoadress","Department":"Department","JobTitle":"Position"}]"

How do I restrict the output of the personal data to output only the name to me?

Thanks in advance,

Dani

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report

Re: MSList to Excel transfer error for the position "Owner"

Hi @DanielH1,

Do you want to only keep the Name of the Person filed in the Select?

Here is a simple demo for your reference, you just need to select the DisplayName parameter of the Person field:

Was this reply helpful? Yes No
DanielH1 7 on at

Like (0)

Report

Re: MSList to Excel transfer error for the position "Owner"

Hey,

thanks for your answer, but i can't chose this possition. I only can choose this one:

I can't choose another possition in this outlook contact 😕
Can I change some "Actions" befor, that it will be showed?

Thanks,
DAniel

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report

Re: MSList to Excel transfer error for the position "Owner"

Hi @DanielH1,

Does this Owner (Outlook) allow multi select?

Could you please go to your column settings and check if it allows multi select?

If so, please try the following method:

Was this reply helpful? Yes No
DanielH1 7 on at

Like (0)

Report

Re: MSList to Excel transfer error for the position "Owner"

Hello, thank you for your answer.

My misstake was, that I had a multiselect. And I don't want mor then one contact. So now it is only one contact allowed and now your first answer works.

Thank you a lot for your solution.

Greetings,
Dani

Was this reply helpful? Yes No