Hi we need to create a Filter Query for Power Automate flow on a SharePoint list. In Get Items we would like to only return everything where created date is more than 10 days in the past. I have tried from looking at other on line posts but can't seem to get the exact correct syntax. If you could suggest how to write this Query would appreciate your help.

1 Answer 1


Check out this Powerusers thread; its requestor was performing a similar task as you. Per the thread, in your existing flow you'd:

  1. Add an action: Get past time. This action is available via the Date Time connector.
  2. Update Get items action /Filter Query: Created gt @(body('Get_past_time')

*If the date needs to be reformatted, I believe you may want to use a variable and the formatDateTime function.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.