Unanswered

Get emailsv 3 didn't count all emails for the day I set.

(0) Share

Report

Posted on by TomLin

Does anyone can take a look why it only filter a few emails for my flow, it didn't count all emails for the day I needed. thanks.
my flow is using:
Recurrence -> Get emails V3->initialize variable->Compose->Sent Emails V2

Here is what I set for each actions:

For Recurrence:

Interval

Frequency

Day

Time Zone

(UTC-04:00) Atlantic Time (Canada)

For Get Emails V3:

Folder

098. ICT Ticket

Search Query

formatDateTime(convertTimeZone(addDays(utcNow(), -1), 'UTC', 'Atlantic Standard Time'), 'yyyy-MM-dd')

For Initialize variable

Name

counter

Type

Integer

Value

length(body('Get_emails_(V3)')?['value'])

For Compose:
Inputs

From Variables counter

For sent emails v2:

abc@novascotia.ca

Subject

Daily email count

Body

From Compose Outputs

Thank you for your kind time to take a look.

2024_02_23_08_26_55_Edit_your_flow_Power_Automate_and_4_more_pages_Work_Microsoft_Edge.jpg

2024_02_23_08_32_08_Edit_your_flow_Power_Automate_and_4_more_pages_Work_Microsoft_Edge.jpg

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (0)

TomLin 20 on at

Like (0)

Report
Copy link

Link copied!

When I tried the TOP for the day more then 35 emails, it only can count to the maximum number I set for top... that means if I set TOP, it will be limited by TOP, if I move TOP, it will be limited by 10 as default if I were used search inquire.

Any suggestion? thanks

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @TomLin ,

I think I have used this 'Get Emails' of outlook long back. I suppose there is an option to filter Read and Unread emails.

Try using both of them and check if you find you missing emails in them.

If yes, then later you can filter/concat or union those final values of emails.

I hope this helps

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Have a look at this freeware: https://ivasoft.com/countemailsflow.shtml

Was this reply helpful? Yes No
TomLin 20 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help, but it doesn't work, as it
no matter how I create a new connection or reconnected, it always shows not items

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Create 2 connections and select them - what's the problem?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Hi @TomLin,
any progress?

Was this reply helpful? Yes No
TomLin 20 on at

Like (0)

Report
Copy link

Link copied!

Apologies for the delayed response as I was busy yesterday.
I have noticed that all four connections are showing as connected, but there is no option to select any of them, and attempting to create a new connection also fails.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Did you click "Refresh list"?

Was this reply helpful? Yes No
TomLin 20 on at

Like (0)

Report
Copy link

Link copied!

Yes, I did try couple times to refresh but the same.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Hmm, and what happened after clicking "Create new"?

Was this reply helpful? Yes No