Unanswered

Sharepoint list get previous month of data

(0) Share

Report

Posted on by PA-15051058-0

I am trying to create a flow that will extract the last months worth of data from a Sharepoint list and put it into a excel spreadsheet. The month worth of data could be at any point so using the start or end of a month is not an option.

I have managed to get the data out but I am struggling with filtering down to just the last months worth.

So far I have the following:

Thank you for any help.

SMCApps

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @SMCApps

To filter out last 30 days items you can make use of below filter query in 'Get items' action:
Created ge '@{formatDateTime(addDays(utcNow(),-30),'yyyy-MM-ddT00:00Z')}'

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
PA-15051058-0 33 on at

Like (0)

Report

@ManishSolanki

Thank you for this, I have tried and got the following error:
Any ideas?

Not sure if it effects anything, but we use UK date format, I adjusted the date layout in your formula and still got the same error. I also tried using '/' rather than '-' and got the same error.

Thank you for your help
SMCApps

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @SMCApps

You have missed to wrap formatDateTime formula in single quotes. Pls use the below expression, just paste it inside the filter query of 'Get items' action:
Created ge '@{formatDateTime(addDays(utcNow(),-30),'yyyy-MM-ddT00:00Z')}'

If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
PA-15051058-0 33 on at

Like (0)

Report

Hi @ManishSolanki

Thank you this has worked, however this only does the past 30 days, I need the past month.

For example, if this is run on the 16th of a month it should pull data from the 16th of the previous month, this is not always 30 days difference. Is there a way of doing this?

Thank you
SMCApps

Was this reply helpful? Yes No