Answered

How can receive a monthly email with a file from sharepoint ther?

(0) Share

Report

Posted on by UpgradeIT

Hello dear Community i need you help again.

So how can i get a monthly email, with a files from my sharepoint
the files is generated by a other system and never called the same. i have tryede somestuff but seems still im stuck on it

All responses (2)

Answers (1)

UpgradeIT 72 on at

Like (0)

Report

Re: How can receive a monthly email with a file from sharepoint ther?

ty for help i fixed by the way you told me 🙂
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: How can receive a monthly email with a file from sharepoint ther?

Hi @UpgradeIT

First off, thinking about the trigger, you mention it is a monthly file? Does this file always get uploaded to the same folder? Does it have its own dedicated folder? In which case you could use when a "file is created in a folder". We do not need to worry about the file name using this method.

Alternatively, you could use a scheduled "reoccurence" trigger, once a month on the 1st or 28th day of the week. But the problem we have here is that we need to find your file. Here we could use "Get Files (properties only)" action. You could setup an OData filter on the creation date gt a date for each month to reduce the number of files returned and then use filter array on the filename containing a string. So whilst it might not always be named the same, if it contains a similar phrase "LogFile_20210201", we could use a filter on FilenameWithExtension (from get file properties).

Please let me know how you get on.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien