Export list items from a specific view on a SharePoint Online list to a CSV file

[Sam12]

I have set up a Flow that runs every day and exports my items in a SharePoint Online list to a CSV file (see screenshot below). This works exactly as expected.

However, I now have a requirement where I only need to export the items that were Modified today rather than the whole list. I have therefore created a new view in my list to show all those that were Modified today, however I can't find a way to only export the items in this view each day? Any help would be much appreciated.

[sudharsan1985]

Hi @Sam12 

In your 'Get Items' action, click 'Show Advanced Option' and try to use the 'Filter Query' field to filter the modified date which is equal to today's date.

Modified eq 'yyyy-MM-dd'

You can also use the expression for the current date as 

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

 Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

[Sam12]

Thanks @sudharsan1985. However when I try to add the below into the Filter Query field I get the below error messages:

Modified eq 'yyyy-MM-dd'

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

Any idea?

[sudharsan1985]

Hi @Sam12 

Can you post some screenshots of the current flow.

[v-bacao-msft · Accepted solution]

Hi @Sam12 ,

Please try to paste the following expression in Filter Query and see if it helps:

Modified ge '@{utcNow('yyyy-MM-ddT00:00:00Z')}' and Modified lt '@{addDays(utcNow(),1,'yyyy-MM-ddT00:00:00Z')}'

Best Regards, 

[Sam12]

Thanks @v-bacao-msft - that works perfectly. 

[Sam12]

Hi @v-bacao-msft - this is working perfectly thanks. I just have one additional requirement which I am unsure how to incorporate into the filter query below:

I need to update the logic for any list items to be exported into a CSV file as per the below:

"Modified" is equal to 'Today' OR "Archive Status" is equal to 'Active'

Is this possible?