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 ...
Thanks!
Solved! Go to 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
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
This is absolutly incredible.
Thank you so much for your help. Exactly what I needed.
User | Count |
---|---|
92 | |
45 | |
21 | |
18 | |
16 |
User | Count |
---|---|
136 | |
49 | |
42 | |
36 | |
28 |