web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get Items Filter Query...

Power Automate

Unanswered

Get Items Filter Query Greater Than Date

(0) Share

Report

Report

Posted on by WC-KSTILL

117

Hello,

Can anybody help me figure out why my flow is coming back with 0 results?

We have around 3000 items that have been created since 01-01-2018 and I am trying to grab them using Get item but it's not working.

I had it working for a minute, not sure what I edited but I am going nuts over here... any input if I am doing this correctly?

Basically trying to get all items created on or after 01-01-2018 and now and re-create those items in another list

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

WC-KSTILL 117 on at

Like (0)

Report

I also tried
formatDateTime('2018-01-01T00:00:00', 'M/dd/yyyy h:mm tt')
0 results though

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report
Hi @WC-KSTILL,

When we compare the date in SharePoint, we should format the time format to "yyyy-MM-dd", so please have a try with these syntaxes in filter query:

Created ge '@addDays(utcNow(),-1033,'yyyy-MM-dd')'

or

Created ge '2018-01-01'

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
WC-KSTILL 117 on at

Like (0)

Report

Both of my original worked but I had to enable the threshold in the settings for some reason. How come it doesn't default to all/max threshold. That seems really silly.

Was this reply helpful? Yes No

Join the conversation