Manual trigger - send as attachments all files added to a SharePoint folder since the last time the flow ran

(0) Share

Report

Posted on by Mirela_Raducanu

Hi, i am creating a manual flow to send out an email with multiple attachments.

The attachments have to meet 2 criteria:

- they were added to SharePoint since the last time the flow ran and

- file name must contain the word "Report"

I know how to create a flow that send multiple attachments and to filter based on file names, however i am very stuck on the first step. I don't know how to make the flow only look at the documents added to SP since the last time the flow was triggered.

Appreciate the help.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Manish Solanki 15,099 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Mirela_Raducanu

One possible solution, you may create a custom SharePoint list (lets say, FlowRunHistory) and save the last successful run time of the flow. Next time, whenever you run the flow just lookup the last run time and apply the filter accordingly to get the files or list items.

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

Thanks

Was this reply helpful? Yes No
Mirela_Raducanu 37 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki. Thanks for the tip. Do you know what the syntax for the date filter is? Let's say that the last run was 30 days ago, what would be the syntax to run the flow today? Thank you.

Was this reply helpful? Yes No
Manish Solanki 15,099 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Mirela_Raducanu

You need to write the below query in "Filter query" of "Get items" or get files action to get the files created in last 30 days:

Expression used for filtering past 30 days list items:

Created ge '@{startOfDay(addDays(utcNow(),-30))}'

You may replace utcNow() with the last run date time if you store it in custom list.

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

Thanks

Was this reply helpful? Yes No