web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

MSList to Excel transfer error for the position "Owner"

(0) ShareShare
ReportReport
Posted on by 7

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

 

 

I have the same question (0)
  • v-qiaqi@microsoft.com Profile Picture
    on at
    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:

    vqiaqimsft_0-1685072048173.png

     

  • DanielH1 Profile Picture
    7 on at
    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:

    DanielH1_1-1685104880153.png

     

    I can't choose another possition in this outlook contact 😕 

    Can I change some "Actions" befor, that it will be showed?

     

    Thanks,

    DAniel

     

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on at
    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?

     

    vqiaqimsft_0-1685326560697.png

    If so, please try the following method:

    vqiaqimsft_2-1685327339200.png

    vqiaqimsft_1-1685326963657.png

     

  • DanielH1 Profile Picture
    7 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard