Answered

Invoice count to check for any new items not previously communicated and then send an email if new

(0) Share

Report

Posted on by mthiru_0023

212

I currently have a recurring email that goes out to Accounting on a schedule Monday to Friday. It counts the number of invoices that are not paid. So users may get the same email and same count of invoices. I like to enhance this so that only initial so it does not repeatedly send out this email if the count of invoices is the same from yesterday. Do you have any suggestions for improvement. thanks,

Here is how it looks right now:

Recurrence

Get items: Filter: field_27 eq 'Not Paid'

Compose to count number of invoice from the Get items: length(body('Get_items')?['value'])

Conditon to check the output is greater then 1

Send an email.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mthiru_0023

You need to save the count of invoices with dates in the separate SharePoint list. Please follow the below instructions to achieve this:
1. Create a new SharePoint list, lets say 'Run History'. We will not create any custom columns or fields as we will leverage Title & Created fields for storing count & date.

2. Next, pls add 2 new actions 'Get Items' and 'Compose' before 'Condition' action in your flow:

expression used in compose 2 is
if(empty(outputs('Get_items_2')?['body/value']),0,int(first(outputs('Get_items_2')?['body/value'])?['Title']))
3. Next, modify the condition to check if count matches with invoice count saved in last record of 'Run History' list:

4. Finally, we need to save the count in 'Run History' list in case the count is mismatched, for that we will add 'Create Item' action in 'Yes' path before sending an email:

The whole flow will look like this:

If it solves your problem, then please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mthiru_0023

You need to save the count of invoices with dates in the separate SharePoint list. Please follow the below instructions to achieve this:
1. Create a new SharePoint list, lets say 'Run History'. We will not create any custom columns or fields as we will leverage Title & Created fields for storing count & date.

2. Next, pls add 2 new actions 'Get Items' and 'Compose' before 'Condition' action in your flow:

expression used in compose 2 is
if(empty(outputs('Get_items_2')?['body/value']),0,int(first(outputs('Get_items_2')?['body/value'])?['Title']))
3. Next, modify the condition to check if count matches with invoice count saved in last record of 'Run History' list:

4. Finally, we need to save the count in 'Run History' list in case the count is mismatched, for that we will add 'Create Item' action in 'Yes' path before sending an email:

The whole flow will look like this:

If it solves your problem, then please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
mthiru_0023 212 on at

Like
a
(0)

Report
Copy link

Link copied!

@ManishSolanki , Hi thanks for the response.
I am testing your proposed solution. The Compose results in 0 inputs and outputs so the flow does not trigger the event based on the AND condition. Any advice?

Was this reply helpful? Yes No
mthiru_0023 212 on at

Like
a
(1)

Report
Copy link

Link copied!

@ManishSolanki , please disregard. This solution works.

Was this reply helpful? Yes No