Filtering emails displayed in a gallery

(0) Share

Report

Posted on by cnr

144

Hi all,

I am trying to filter the emails that show up in my gallery so that the only emails displayed are those that contain an ID called the "Trade Number"

However I have not been very successful. The emails showing are not correct. My connector is below, with varTradeNumber being the variable holding the Trade Number. Would anyone have any suggestions ?

Office365Outlook.GetEmails(
 {
 folderPath: "Inbox",
 fetchOnlyUnread: false,
 searchQuery: varTradeNumber
 }
)

Thanks,

Conor

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @cnr
I tried the same with the formula

Office365Outlook.GetEmails({fetchOnlyUnread:false,searchQuery:txtSearchInput.Text})

I was able to fetch the results for 12398

Can you confirm if varTradeNumber is actually holding value if it's not holding any value or ="" by default all Inbox content would be shown in gallery
Try: Can you try with the Input field and check

Thanks

Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
cnr 144 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Shujaath_Khan ,

Thanks for the reply, it seems that now I retrieve some but not all the emails. I checked and the variable varTradeNumber did have a value.

Was this reply helpful? Yes No
Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cnr
You can also try to use top: limit ( top : 500)

Office365Outlook.GetEmails({fetchOnlyUnread:false,searchQuery:txtSearchInput.Text, top:100})

Similar thread on throttling limit https://powerusers.microsoft.com/t5/Building-Power-Apps/Office365-GetEmails-only-shows-25-mails-from-a-useraccount/td-p/113448

Thanks

Was this reply helpful? Yes No
WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cnr ,

You can only retrieve the first 25 emails - if you follow the thread link posted by @Shujaath_Khan , you will see that this is the limit mentioned there too. Here is a test to confirm this

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @WarrenBelz

The same limit is applied on Power Automate either.

The workaround I could see here to rely on graph API via Power automate.
https://graph.microsoft.com/v1.0/me/messages?$top=100&$search="viva"
Thanks

Was this reply helpful? Yes No