Query within Power Automate

[pbi_besi]

Hi,

I have used a Power BI query within Power Automate with the Power Automate step "Run a query against a dataset". Now, I want to make the date specification dynamic so that today's date is always pulled. 

The query looks like this: 

FILTER(

KEEPFILTERS(VALUES('Mail'[DateTimeReceived])),

AND(

'Mail'[DateTimeReceived] >= (DATE(2023, 10, 17) + TIME(15, 1, 40)),

'Mail'[DateTimeReceived] <= (DATE(2023, 10, 18) + TIME(15, 1, 40))

I would like to replace (DATE(2023, 10, 17) + TIME(15, 1, 40)) with utcnow(), but then it gives me the following error message:
'The template language function 'utcNow' expects its parameter to be of type string. The provided value is of type 'Integer'.

Can someone help me?

Thanks a lot!

[Abhinav054 · Accepted solution]

Hii, once try this

FILTER( KEEPFILTERS(VALUES('Mail'[DateTimeReceived])), AND( 'Mail'[DateTimeReceived] >= ToString(utcNow(), "yyyy-MM-dd"), 'Mail'[DateTimeReceived] <= ToString(utcNow() + DateDiff(DAY, 1), "yyyy-MM-dd") ) )