I am trying to create a flow to send an email weekly with excel doc from Sharepoint and save it .

[Shivaji]

Hey,

I have an Excel file in sharepoint that we distribute every Friday at 12pm (same time) every week to the same group of people. Once they update the excel file it has to be saved in the sharepoint were it has been started.

I would like to create a flow that will eliminate the need to do this manually. 

Does anyone have any thoughts on where to begin and how to do it. 

Basically,

1) Tigger on particular time period.

2) Send an Email to a group of people with an excel file (from sharepoint )

3) Once they update the excel file, it has be updated in sharepoint(Excel original file). 

Is there any possibility to have audit log (what time they submitted or changed the file).

Is this Possible ? or any alternate ways are there instead of Sharepoint ?

Any help is appreciated!! 

[ChristianAbata · Accepted solution]

hi @Shivaji  shure you can do this.

the last step you said is a trigger so you need to define of you are going to use when a file is modified of if is a recurrence as my example

[v-alzhan-msft · Accepted solution]

Hi @Shivaji ,

For the first part to send an email with attachment from sharepoint document to user, you could refer to @ChristianAbata 's steps.

And for the second part, do you want to update the file in sharepoint library when the attachment is modified by user? If yes, your requirement is not easy to achieve. you need to save the attachment to the onedrive folder in the first flow for user to update it.

 So you create another flow to trigger when an file is modified in the folder, flow then search for the file in sharepoint library and update it.

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-alzhan-msft]

Hi @Shivaji ,

Have your problem been solved now?

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.