cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AB1
Level: Powered On

undefined

Helpppp! 

 

Im not sure where to even start! I work in a high school and we want to send out progress reviews to students parents as a email with the attached progress review (a PDF which is going to be called the students name) - Can this be automated using flow some how? 

 

Thanks! 

8 REPLIES 8
Super User
Super User

Re: undefined

@AB1 :

 

This process can be automated using Flow.

A few questions:

  1. You'll need a list of email addresses - where will you store them (SharePoint woiuld be a good choice)
  2. You'll need a link between the pdf files and the email address - how can they be matched up?
  3. Where will the pdf files be stored? (SharePoint would be a good choice)
  4. Do you want the emails to go out automatically?
  5. Do you want the emails to go out all at once?

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
AB1
Level: Powered On

Re: undefined

The emails I can put in a sharepoint list. 

 

The PDFs will be the students names and the emails will be the parents but in a sharepoint list is it possible to have a column next to the emails the students name? (so that the PDFs which will be the students name be linked to the students name in the sharepoint list which will be next to the parent email)

 

The PDFs I can aloo store in sharepoint. 

 

I would like the emails to go out automaticially all at once (only goes out every 3 months but I would like to click a button to send them all out or something similar)

 

Thanks

 

Aran

 

Community Support Team
Community Support Team

Re: undefined

Hi @AB1 ,

 

You could use Recurrence as a trigger to trigger Flow every three months.

I assume that each student corresponds to a separate pdf file, and each student corresponds to a separate item, you could consider storing the PDF file in list item-attachment.

70.PNG

If this is the case, Flow configuration can be similar to the screenshot below:

68.PNG69.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AB1
Level: Powered On

Re: undefined

Thank you for your response! I will give this ago, but instead of a Recurrence trigger is it possible to do it as a manual one as I have just found out that they go out at different dates each year also is there an easy way to import each student corresponding to a separate pdf file to a sharepoint list. 

 

I know its drag and drop but with attached PDFs im not sure how to import this.

 

Thanks

AB1
Level: Powered On

Re: undefined

Thank you for your response! I will give this ago, but instead of a Recurrence trigger is it possible to do it as a manual one as I have just found out that they go out at different dates each year also is there an easy way to import each student corresponding to a separate pdf file to a sharepoint list. 

 

I know its drag and drop but with attached PDFs im not sure how to import this.

 

Thanks

Community Support Team
Community Support Team

Re: undefined

Hi @AB1 ,

 

You could use Button as a trigger so that you can manually trigger Flow by clicking the button on MS Flow app.

73.PNG

Or click Run now to manually trigger Flow:

71.PNG

Regarding the import of pdf files, it is recommended to use manual import files, which can ensure the accuracy of the files and avoid the pdf files and students do not correspond.

72.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AB1
Level: Powered On

Re: undefined

Thank you, 

 

Is there a way to have the attachments in a library on sharepoint (or else where) instead of in the same list as we have around 1500 students and manually adding each one will be a long process and progress reivews change yearly so that means we will have to add it manually every year I was hope flow could make it slighly less time consuming.

 

Thanks again

AB1
Level: Powered On

Re: undefined

Can this be done?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,528)