Forum Discussion

pbi_besi's avatar
pbi_besi
New Member
2 years ago
Solved

Query within Power Automate

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!
  • Anonymous's avatar
    Anonymous
    2 years ago

    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") ) )

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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") ) )