Hello,
I'm using below flow, which filters Current Month and displays the overall sum from Spend Amount column
In Get Items filter query below expression is used:
(CompletionDate ge '@{utcNow('yyyy-MM-01T00:00:00')}') and (CompletionDate lt '@{addToTime(utcNow('yyyy-MM-01T00:00:00'), 1, 'Month', 'yyyy-MM-ddT00:00:00')}')
For a Post message in Teams, I've used below expression for MTD Count:
length(body('Select'))
And below expression for MTD Greater than 0 Spend
formatnumber(xpath(xml(outputs('JSON')), 'sum(/root/Numbers)'), 'C2')
The flow that I have, gives me overall spend, whereas I'm looking to have 2 different rows i.e. one for Greater than 0 and one for less than 0 (in below format):
But the MTD count should show overall count of current month. For e.g. in above screen shot:
Total Count = 47
Greater than 0 = $720,999.44
Less than 0 = ($567,45.22)