Building flow to save file in sharepoint under their subject name

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear All,

I would need your urgent support on how to create the following flow:

Here is the situation:

I receive 7 file a day with different file names under same email subject
Currently I do it manually where I overwrite the files everyday

I need to build the following flow:

The flow should allow me to automatically store these files in Sharepoint, under the email subject name and not actual file name
this should be done daily at 7 A.M for all 7 files
below is an example of how I receive the file and how I wanted to be stored

I really appreciate your support in advance!!

Please keep in mind that I am new to Power Automate and not an expert!

Thanks and regards.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Sort by

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

as far as I understood your requirements right your flow should look like this:

Expressions I used in the Flow:
split(string(items('Apply_to_each')?['name']),'.')
concat(triggerOutputs()?['body/subject'],'.',last(variables('subjectName')))

What we basically need to do here is split the attachments name and use '.' as separator. We need the ending / file type of this. Next is using concat to add to your subject name a '.' and the extension.

It will create each time a new file in your SharePoint library, if the file exists already it will overwrite and create a new version if versioning is enabled in your library.
Enabling versioning: https://support.microsoft.com/en-us/office/enable-and-configure-versioning-for-a-list-or-library-1555d642-23ee-446a-990a-bcab618c7a37

In the trigger of the Flow you can be more precise and filter only Mails with special SubjectName, from special people etc...

Hope this helps you 😉

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you for sharing: so basically this flow will ignore the actual name of file received bye email and this file name will be replaced with subject email?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Can you please share the final outcome of the flow you have shared (meaning file name received by email and how it is stored in sharepoint).
thank you in advance and I appreciate your support!

Was this reply helpful? Yes No
GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes Mail Subject will be new file name.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Dear GeorgiosG,

I can see that you write the subjectName.xlsx in the field subjectName I need to apply this to seven files at once and not only one since every file has a different subject name.
Can above flow works or need to be ammended

Was this reply helpful? Yes No
GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

this flow will:

Create a document for each attachment in a mail
use the original file type
use the mail subject as file name
if a mail has two attachments with the same file type, it will overwrite the file in SharePoint (or create a new version if versioning is enabled)
this flow works dynamically for all mails with attachments
Hope this helps you 😉

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Great that sounds exactly what I am looking for
One last question: will the flow run any time a new email email is received or do I have to schedule it.
sorry I am still new to the Power Automate

thank you in advance

Was this reply helpful? Yes No
Verified answer

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

It will run everytime you receive a mail, 👍 yes.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Dear Georgios

First please find below how I set the initialize varibale for SubjectName and if it is correct?

My question is that the file will be saved under Email subject name which is in my case: AMCA0602 - SCHQFP 011 A-L A-W 06 06, is that correct?

Thank you a lot for the support!

Was this reply helpful? Yes No