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

Flow between Outlook 365 and SharePoint.

Hi All, 

  1. Problem -
  • We have to upload the following things to sharepoint on monthly basis : (A-0XX = Email Subject or From)
  1. A-023 : email (.msg) with date appended
  2. A-024 : “ ”
  3. A-025 : “ ”
  4. A-048 : “ “
  5. A-051 : “ ”
  6. A-011 : only attachment with date appended
  7. A-050 : “ ”
  8. Queries : save only attachment 
  • So, in total we have to save 150 email and append date to each of them.
  • Open 60 email, save individual attachment and then append date to each.
  • Open 30 email and save attachments.

What I want :

  • When these emails arrive into my mailbox, just upload them to sharepoint.

Scenerios (What needs to be uploaded) :

  • Save Outlook email (.msg file) with date appended explicitly to a Specific folder in Sharepoint. (If folder does not exists it should create it [Ex. each month]). Based on date it should put the file in the corresponding folder.
  • Save only attachments and not messsage.
  • Save only attachments with date appended explicitly [date = previous day] and not message. 

Can we write some code (if-else conditions - while appending date, date functions) while creating flows?

I need different flows for individual task (above mentioned 8). No need to create a single flow.

Please help.

Thanks in advance!

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Flow between Outlook 365 and SharePoint.

Hi @vaibhavvijay9,

 

You could use expression in a Condition or appending date, date functions when create a flow.

Could you please explain more details or examples about your requirement for fully understand so we could provide a proper workaround for you?

 

Or you could take a try to create the flow to achieve your needs and you could ask for help here if you have any problems.

 

Best regards,

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.

 

vaibhavvijay9
Level: Powered On

Re: Flow between Outlook 365 and SharePoint.

Details :

Point 1. to 5. - When an email arrives into Outlook 365 mailbox the complete email message (.msg) file should get uploaded to a specific SharePoint folder.

Example : If message arrives with subject as "A-023" on 10-Feb-2019 , it should get uploaded to TeamXYZ->A-023-->2019-->Feb_2019 : A-023_Feb 09.msg

Sharepoint Folder Structure : 

"TeamXYZ --> 

      . A-023 -->

            .2019-->

                      . Jan_2019

                      . Feb_2019 and so on.

Point 6. to 7. - Only save attachment to folder.

Example : If message arrives with subject as "A-011" with a text file (Report.txt) as attachment on 05-Feb-2019 , it should get uploaded to TeamXYZ->A-011-->2019-->Feb_2019 : Report_Feb 04.txt

  • Sharepoint Folder Structure : Similar as above
  • Exact Condition If email is received on Monday (ex. 11-Feb), the date appended to fileName should not be previous day's but it should be Friday's date i.e today-3. (Report_Feb 08.txt)

Point 8. - Only save attachment to folder, no conditions or renaming.

Example : If message arrives with subject as "Queries" with some attachments on 14 Feb 2019, it should get uploaded to TeamXYZ->Queries-->2019-->Feb_2019. 

No data should get lost from Outlook. Don't Move just Copy.

If you need any further details, I will be happy to provide inputs.

 

Dev_Nikhil
Level 8

Re: Flow between Outlook 365 and SharePoint.

Hi @vaibhavvijay9 ,

If you have static Subjects that you are mentionning here in your question, You can create a Seprate flows or you can Combine all the Incoming Emails into One Flow and then you have to check the condition for the Subject of the Incoming Emails.

 

Something like below, Hence i am not sharing the Whole process here.

However it would help you to Jump Start for your Solution with sorting out the Emails based on the Subject.

 

Capture.PNG

and if you have any other subjects then you can create Multiple conditions as per the recent update of Microsoft Flow.

 

please feel free to post if you have any issue or query into the described process or in case for further process.

 

Regards,

Dev_Nikhil

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,179)