My get Items fitler query dosnt work

(0) Share

Report

Posted on by JustusCk

I have a get Items action in my Flow and i want that action to only give me the items where the Date field "Datum der nächsten E-Mail"(Date of the next E-Mail) is at the current date for that i use the filter:

with the colum name: Datumdern_x00e4_chstenE_x002d_Ma because thats the name of my colum in the URL of the colum settings.

And with:

formatDateTime(utcNow(), 'yyyy-MM-dd')

in the formateDateTime. I also tried diffrent formats like 'dd-MM-yyyy' or 'dd.MM.yyyy' they all didnt work. The error Message is:

"Der Ausdruck (The Expression) "Datumdern_x00e4_chstenE_x002d_Ma eq 2024-01-15" ist ungültig (is invalid) . Creating query failed.
clientRequestId: e8545623-0a5e-456c-b045-875e2d22da44
serviceRequestId: e8545623-0a5e-456c-b045-875e2d22da44"

All responses (1)

Answers (0)

Craig Stewart ABZ 957 Super User 2024 Season 1 on at

Like (1)

Report

Re: My get Items fitler query dosnt work

Hi

You're missing ' either side of your expression on your query.