I've been trying for a while now to extract the last week's entries from a spreadsheet. I've learned about ticks, as that's what my spreadsheet is putting out:
| Original sheet | Processed sheet (unfiltered) |
 |  |
So I composed my expression to get the excel tick date for 7 days ago:
int(div(sub(ticks(addDays(utcNow(),-7)),ticks('1899-12-30')),864000000000))
It works, and outputs the right tick date as I'd hoped
But when I run my comparison as shown
I get the following error:
Unable to process template language expressions for action 'Condition' at line '1' and column '27165': 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.
Although Excel is spitting out a tick date (e.g. 43955.42), Power Automate is still reading it as a string and I can't change it to an integer. I just don't know where I'm going wrong.
I've been at this all day and will have to come back to it tomorrow... hopefully with your answers awaiting me!
