Answered

Office365Outlook.ContactGetTablesV2()

(0) Share

Report

Posted on by ghdunn

409

I am struggling to get Office365Outlook data connector working. I can get the Office 365 Users connector working, but when I to source, for example, ContactGetTablesV2(), then the Primary Text Data Fields are not accessible.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@ghdunn
You can do this by putting this code in the Items property of the ComboBox instead
Office365Outlook.ContactGetTablesV2().value

How did I know this? Office365Outlook.ContactGetTablesV2() returns a Collection. When troubleshooting collections it is often helpful to see what the data structure looks like. To do this I stored Office365Outlook.ContactGetTablesV2() in a Collection, then I wentto the View tab on the top menu of PowerApps Studio and clicked on Collections. From the image below we can tell we need to add ".value" to expand the table.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
ghdunn 409 on at

Like (0)

Report
Copy link

Link copied!

thanks @mdevaney

that moves me forwards, but not quite to where I thought I would be.

I am trying to bring back a list of contacts.

If I use Office365Outlook.ContactGetItemsV2("Contacts").value

then I get to see the following table...how do I access fields in that table?

Was this reply helpful? Yes No
ghdunn 409 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney

or maybe I have cracked it 🙂

Office365Outlook.ContactGetItemsV2("Contacts").value.displayName

Would that be the favoured way of doing this?

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

@ghdunn
Yes, you have done it well! I can see that you understand the new concept here. When working with a table or a record you can type dot and the name of the property to select it (example: SomeTable1.Result)

Great work!

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
CU17031922-0 21 on at

Like (0)

Report
Copy link

Link copied!

PowerApp

I am trying to pull Outlook contacts from outlook. I am using Office365.ContactGetItems("Contacts").value. It works with Default contacts folder but i have Sub contact folder called Subcontacts.

When I try to use Office365.ContactGetItems("Subcontacts").value, i got following error
Office365.ContactGetItems failed: { "status": 400, "message": "Id is malformed.\r\nclientRequestId
"error": { "message": "Id is malformed.", "code": "ErrorInvalidIdMalformed", "originalMessage": "Id is malformed." }, "source": "office365-wus.azconn-wus-001.p.azurewebsites.net" }

Please help

T

Was this reply helpful? Yes No