I would like to create a Flow so that once a day I can export new list data from a SharePoint Online list into Smartsheet so that a dashboard can be displayed to managers with this data.

I have been able to setup the Schedule action just fine, and the actual import of data into Smartsheet action is fine, but the Get Items SharePoint action is pulling in all list items every time.

Will I need to setup an additional column/action to track if the item has been moved to Smartsheet already so that I can filter down the Get Items action?

  • Not answer, just a question : any specific reason to choose that approach over a search based approach? Commented Aug 2, 2018 at 14:49
  • I'm not sure what you mean by a search based approach?
    – vanblart
    Commented Aug 2, 2018 at 15:12

1 Answer 1


You could use Filter array to filter the items.

For example: use addDays(utcNow(),-1) to filter Created greater than yesterday.

enter image description here

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.