Flow to export people picker data from list

[rdalrymple]

Hi,

We have a nice clean list that details allot of information. We have a need to export that data to excel but want to capture additional  information from the people picker field. So someone's e-mail address and phone number etc.  As you can see the infomation below in the screen shot. Is this possible?

[v-duann-msft]

Hi @rdalrymple

Thank you for posting.

According to your description, you would like to extract additional information of user from SharePoint and copy them to excel. If any misunderstanding, please kindly let me know.

The email parameter can be extracted from SharePoint directly as long as it comes from people picker type column. We just need to add one more ‘get user profile’ action, then we will be able to get phone number information with no issue.

Here is the flow overview:

Hope the content above may help you.

Best regards,

Anna

[rdalrymple]

@v-duann-msft 

This seems correct however we have multiple columns and in each column there is a people picker with multi select.

We want to gather Phone Number, Email Address & Mobile Phone number for each column and it could be multiple people in each column. Does this make sense?

[v-duann-msft · Accepted solution]

Hi @rdalrymple 

Thank you for your update.

Is this what you want?

List:

Flow overview: (We need to append all required properties into variable):

Flow in detail:

After testing, I'm able to get excel table as below:

Hope to hear from you soon.

Thanks

Anna

[rdalrymple]

@v-duann-msft 

This looks great ill try it, however one other question. Is there anyway to have separate lines in excel like "persons name then there information email, mobile phone, business phone. Then the next persons information. That way it doesnt look all pushed together. 

[v-duann-msft]

Hi @rdalrymple 

Thank you for your reply.

Actually, that was my original purpose ideally. The user information will be pulled into one row and for another person, it will be recorded in another row. I tried and seems it's extremely tough. As we known, we need to append all related information into variable if it's multi-select, but for this scenario, we need to separate them again out of variable one by one. So I suspect it's not feasible now. It doesn't make sense.

Please click Accept as Solution if my post is helpful to you. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Best regards,

Anna