How to connect a Contact list?

[leo-gan]

I have several options to provide a list of contacts:

• Contacts from Office365 (from Outlook?)
• Contacts from SharePoint
• Contacts from database
• Contacts from csv file

All those options work for me. How to coonect to any of these lists? Please, advise.

[v-yamao-msft · Accepted solution]

Hi Leo-gan,

It seems that currently we are not able to connect to a contact list directly.

>Contacts from Office365 (from Outlook?)
You could try to export contacts and save it as Excel, then format the Excel as table, upload it to OneDrive or Drop box, then connect to the Excel file.
This file about “Export contacts from Outlook” for a reference:
https://support.office.com/en-us/article/Export-contacts-from-Outlook-10f09abd-643c-4495-bb80-543714...

>Contacts from SharePoint
We are able to create a connection to SharePoint custom list but not able to connect to a default SharePoint list.
Please check this document for more details:
https://powerapps.microsoft.com/en-us/tutorials/connection-sharepoint-online/

>Contacts from database
Which database do you mean?

>Contacts from csv file
CSV file is currently not available to PowerApps. You could convert it to Excel file then create a connection to the Excel table.

Please consider to submit an idea on PowerApps Ideas Forum about all these requests. I will also report this from my side.

Best regards,
Mabel Mao

[AHanlon]

We're you aiming to use the Contacts power app like a phonebook? And did you find a workable solution?

I've got an excel file with contact details and want to turn it into a client phonebook. Any pointers would be much appreciated.