Office365.GetEmails(...) only shows 25 mails from a useraccount

[JanLektonen]

I'm retrieving e-mails from Office365 via this powerapp function:

Office365.GetEmails({folderPath: displayMailsFrom, fetchOnlyUnread:false, top:25, searchQuery: TextInputSearchMails.Text})

My problem is that I would like to list more than 25 emails to the user. How do I achieve this. The documentation only gives me a choice to use "TOP:25" and get 25 e-mails to display in gallery.

How do I retrieve the rest/more of the e-mails?

[v-micsh-msft]

You should be able to specify the a larger number in order to get more Emails, the default value for the top Syntax is 10:

For example, to get 100 Email, specify the Top parameter as 100:

Office365.GetEmails({folderPath: displayMailsFrom, fetchOnlyUnread:false, top:100, searchQuery: TextInputSearchMails.Text})

For more ifnormation about this action, see:

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

Regards,

Michael

[JanLektonen]

Thanks - but it is only possible to retrieve 25 emails. Please try it out and you will se that the maximum mails in the list will be 25 e-mails.

[ManishM]

This does not work with GetEmails or with GetEmailsV2. It is restricting to 25 emails and forces to mention that in the code. I tried top:26 and gave the error. see the screen shot.

[Django]

Any update on this?

I see the 25 limit is not mentioned in the documentation --> this would be very wise to do:

• https://docs.microsoft.com/en-us/connectors/office365connector/ 
• https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-office365-outloo...

[db1989]

I had the same issue and was thinking about a possible workaround.

What if I am just use a combination of multiple collect statements?!

The first collect statements clears the collection and takes the top 25 e-mails.

The second collect statements skips the first 25 messages and then takes the top 25 messages.

The third .........

Aren't we now able to collect as many e-mails as we want by just adding more collect statements?

[Django]

I like the way you think 😉

If you test please let us know what the results are. I can think of the following issues:

1. Perfomance issue for end user
   (because every collect is a new request for data the network connection needs to act every collect) 
2. Throttling limits (see https://docs.microsoft.com/en-us/connectors/office365connector/)
   (because there is a throttling limit in most connectors the number of API requests can be maxed)

[db1989]

FYI I am not planning to fully testing the idea as my business case is now a different one.

[Terzsian]

I don't know if this is still relevant, as far as I am concerned, I did not find any other solution than to implement @db1989's approach. This is my code, in an OnSelect property (button or icon) and it creates a collection holding 250 e-mails. This is my first iteration of the solution.

ClearCollect(colEmails; Office365Outlook.GetEmails({folderPath:"Inbox"; fetchOnlyUnread:false; includeAttachments: true; top:10}));;

ForAll(
Sequence(25);
If(
CountRows(colEmails) < 250;
Collect(
colEmails;
Office365Outlook.GetEmails({
folderPath:"Inbox";
fetchOnlyUnread:false;
includeAttachments: true;
top:10;
skip: CountRows(colEmails)
})
)
)
)

[Gillsagain]

Following up on @Terzsian, I have gotten a running copy of the script going.  I made some modifications for my specific instance, below are my notes:
- The script now uses GetEmailV3 (GetEmails is deprecated)
- The script now uses a loading spinner (which has visibility set to EmailLoading)
- The script goes into the OnSelect for an icon
- The gallery displaying emails has the "Items" property set to colEmails
- Each button which intends to filter or update the gallery just selects the icon that has this script

Set(EmailLoading, true);
ClearCollect(
    colEmails,
    Filter(
        If(
            ToggleEmailMode,
            Office365Outlook.GetEmailsV3({ fetchOnlyUnread: false, top: 25 }).value,
            Office365Outlook.GetEmailsV3({ fetchOnlyUnread: true, top: 25 }).value
        ),
        (SearchEmail.Text in subject) || (SearchEmail.Text in from) || (SearchEmail.Text in body)
    )
);

If(
    CountRows(colEmails) < 100,
    ForAll(
        Sequence(25),
        Collect(
            colEmails,
            If(
                ToggleEmailMode,
                Office365Outlook.GetEmailsV3({
                    folderPath: "Inbox",
                    fetchOnlyUnread: false,
                    includeAttachments: true,
                    top: 10,
                    skip: CountRows(colEmails)
                }).value,
                Office365Outlook.GetEmailsV3({
                    folderPath: "Inbox",
                    fetchOnlyUnread: true,
                    includeAttachments: true,
                    top: 10,
                    skip: CountRows(colEmails)
                }).value
            )
        )
    )
);
Set(EmailLoading, false)

I also have a button which toggles unread/all with the below script in its' OnSelect property:

If(ToggleEmailMode = true, Set(ToggleEmailMode,false), Set(ToggleEmailMode,true));
Select(EmailLoader)

To enable this gallery to load the first time you navigate to this screen, but no other time, I set each button which navigates to this screen with the below script:

Navigate(EmailView);
If((ECounter = 1),
Set(ECounter, 2));
If(IsBlank(ECounter),
Set(ECounter, 1))

I also set the screen to have the below OnVisible property:

If (ECounter = 1,Select(EmailLoader))