How to read e-mails in PowerApps Application with Office365Outlook.GetEmailsV3

[llechat]

Hey. My question is simple. I'd like to display my e-mails from outlook in my PowerApps Application. To do this action i have created an canvas application with an gallery. I'am connected with Office365Outlook. In the "Items" from "TemplateGalleryList" I have typed "Office365Outlook.GetEmailsV3({fetchOnlyUnread:false})". But how i have to do for display Title and corp message (in "Title2" and "Subtitle2") ? No field name is offered to me in this fields except "Thisitem.sampletext". I don't understand... Thank you for your helps 🙂

[llechat]

In fact i've seen that's the method "GetemailsV3" does not work. With the method "Getemails" PowerApps propose to me all the fields and it does work. Very strange ! 🤔

[v-yutliu-msft · Accepted solution]

Hi @llechat ,

Do you mean that you could use  "Getemails" function, but couldn't use  "GetemailsV3" function?
Firstly, let me explain why you met this problem.

The key point is the results that these two functions return are different.

"Getemails" function will return a table named ClientReceiveMessage. Its structure is like this:

So you could directly use this in the gallery's Items. Its result is a table with fields: from, subject,....

Office365Outlook.GetEmails({fetchOnlyUnread:false})

While "GetemailsV3" function will return a table named BatchResponse[GraphClientReceiveMessage].

Its structure is like this:

 It is a table with a field named value and its data is array of ClientReceiveMessage.

So If you want the table like "Getemails" function turns, you need to use this formula in your gallery's Items:

Office365Outlook.GetEmailsV3({fetchOnlyUnread:false}).value

Notice you need to add ".value".

Here's a doc about this connector, you could check the result that all the functions return:

https://docs.microsoft.com/en-us/connectors/office365/

Best regards,

[llechat]

Thanks you for this explanations. It's very clear 🙂

[llechat]

I've two last question.

1/ How is possible to obtain value of a specific field with 

"Office365Outlook.GetEmailsV3({fetchOnlyUnread:false}).value"

I mean. If i want to access to "body" or "from" etc. How is possible to display the value of specific field ? 

2/ How is possible to refresh "Items" with new mails ?

Thanks a lot

[joeinmay]

Insert a button "B1"

B1-> OnSelect -> ClearCollect(Mail01, Office365Outlook.GetEmailsV3({fetchOnlyUnread:false}).value)

Next add a blank Gallery

Next add a label "L1", "L2","L3"....etc

L1 ->Text -> ThisItem.from

L2->Text -> ThisItem.subject

L3->Text -> ThisItem.bodyPreview

…….…..hope this helps 🙂