Creating a complex flow with summaries DYNAMICS 365

(0) Share

Report

Posted on by alexyoy111

Hello,

To the next task I do not know if it can be done through flow (Power Automate).

On our Dynamics 365 we have daily API which create records from third Part Source. the record look as follow

tenant	date	consumption
1	01/01/2020	1
1	01/02/2020	2
2	01/03/2020	1
2	01/03/2020	1

Using Power Automate we would like to summarize the consumption per tenant and every seven day if the total consumption is more than 7 send an email If it's less than 7 to ignore.

Can something like this be achieved by power automate?

🙂

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Shure you can @alexyoy111 you need to use Filter Array to get just the values by tennant so then you can compare if some of that values are more than 7 then send email.

Or you can save your rows into a sharepoint list and then get the values from the sharepoint list to do the same compare.

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @alexyoy111 ,

Could you share an example of the summarize email?

Do you want to check from the records for date on previous 7 days or each tenant, and count the total consumption for each tenant on the previous 7 days?

If yes, please share the entity and let me know, I would provide the steps to create the flow.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
alexyoy111 56 on at

Like (0)

Report
Copy link

Link copied!

@v-alzhan-msft thank you very much for your response. How would you like me to share the entity? do you need the list of field or a screenshot of the form?😊

Was this reply helpful? Yes No

alexyoy111

56 on at

Like (0)

Report

Copy link

Link copied!

@v-alzhan-msft Maybe this example will help you more to understand my need

Assuming this is the data I have and each record created automatically each night.

I would like to get an email alert when the total consumption in the last 7 days is higher than 7 (Which can indicate to my team that maybe there is an issue with the water meter and need to be investigated).

Obviously this alert can go on and on every day until the issue had been fixed and the conception is back to reasonable use

So in this example I would like to get an alert on 09/03/2020 saying "pay attention to tenant TN0416 thee conception is unreasonable"

The date format id DD/MM/YYYY

Name data	consumption	date	meter id
TN0416	0.10	01/03/2020	18153873-W
TN0416	0.50	02/03/2020	18153873-W
TN0416	0.30	03/03/2020	18153873-W
TN0416	1.10	04/03/2020	18153873-W
TN0416	1.20	05/03/2020	18153873-W
TN0416	1.00	06/03/2020	18153873-W
TN0416	1.00	07/03/2020	18153831-W
TN0416	1.10	08/03/2020	18153831-W
TN0416	1.00	09/03/2020	18153831-W
TN0416	0.50	10/03/2020	18153831-W
TN0416	0.30	11/03/2020	18153831-W
TN0416	0.10	12/03/2020	18153831-W
TN0416	0.80	13/03/2020	18153831-W
TN0416	0.30	14/03/2020	18153831-W
TN0416	0.70	15/03/2020	18153951-W
TN0416	0.60	16/03/2020	18153951-W
TN0416	0.10	17/03/2020	18153951-W
TN0416	0.50	18/03/2020	18153951-W
TN0416	0.30	19/03/2020	18153951-W
TN0416	0.10	20/03/2020	18153951-W
TN0416	0.80	21/03/2020	18153951-W
TN0416	0.30	22/03/2020	18153969-W
TN0416	0.70	23/03/2020	18153973-W
TN0416	0.60	24/03/2020	18153973-W
TN0416	0.50	25/03/2020	18153973-W
TN0416	7.00	26/03/2020	18153973-W
TN0416	0.10	27/03/2020	18153973-W

Was this reply helpful? Yes No

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @alexyoy111 ,

So the flow would check from the items for the previous 7 days on?

In your example, the alert would be sent on 10/03/2020, and the records from 11/03/2020 to 27/03/2020 is not existed on 10/03/2020, right?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
alexyoy111 56 on at

Like (0)

Report
Copy link

Link copied!

@v-alzhan-msft That's correct the records are not exist at that time.

Obviously they will be create on the next day but at the time of the alert they are not exist yet.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @alexyoy111 ,

I would share the solution on a sharepoint list:

you could refer to my solution to create the flow:

Expression in the Filter Query:

addDays(utcNow(),-7)
addDays(utcNow(),-1)

Expression in the Compose 2:

union(variables('Name data'),array(outputs('Compose')))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No