Email me a weekly summary of Office 365 Message Center notices (Custom)

[mikedumka]

Hi there everyone,

I was looking at this blog post becuase I (and my team) want to be notified when there are any new messages from the Office 365 Message Center. 

https://flow.microsoft.com/en-us/blog/get-office365-health-notices-using-microsoft-flow/

The problem is I get this huge list, and it is being displayed from old to new. How can I ...

1. Only show what is new for that day
2. Reverse the order to display new to old 

Thanks!

[v-yuazh-msft · Accepted solution]

Hi @mikedumka,

Do you want to get messages from last monday to current time for the last flow has run to the new  runs?

If yes, I have made a test on my side, you could modify the expression in the Filter Array as below:

The expression as below:

@and(equals(item()?['MessageType'], 'MessageCenter'),greaterOrEquals(item()?['StartTime'], addDays(utcNow(), -7)),lessOrEquals(item()?['StartTime'], utcNow()))

If you want to display the messages from new to old, please refer to screenshot to modify your flow:

The expression in the Compose as below:

union(array(items('Apply_to_each')),variables('Messages'))

Best regards,

Alice

[mikedumka]

This is absolutly incredible. 

Thank you so much for your help. Exactly what I needed.