Answered

Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

(1) Share

Report

Posted on by ahmehade

Hey everyone,

I have currently created a work flow triggered by MS Forms. The form itself is for event booking. A user can use this form to request a specific room to be booked for an event planned for the future. I have automated the responses to be processed as a PDF and uploaded to SharePoint, however, I want to automate the files to be organized in their respective MM/YYYY folder based off the file name and NOT the date the form was submitted. is this possible?

Example:
File created: 2023/12/25-TitleofEvent.pdf
Automate file to move to/create folder: December 2023

I have copied another workflow which can do this based off the date the form was submitted but ideally i want to upload these to the date the event is organized for.

Thanks all!

All responses (7)

Answers (1)

ahmehade 15 on at

Like (1)

Report

Re: Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

Amazing, thank you so much!

That worked perfectly 🙂
Verified answer

abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

Hi @ahmehade

This is what you need for the newer format

Expression

concat(formatDateTime(substring(outputs('Compose'),0,10),'MMMM'),' ',substring(outputs('Compose'),0,4))

Thanks
ahmehade 15 on at

Like (1)

Report

Re: Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

Yes you are correct, My apologies.

I am using the second format you mentioned (2023-12-25-TitleofEvent.pdf)

Again, thank you so much for the assistance!
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

I think I figured out

Initially you said your filename format is like below.

2023/12/25-TitleofEvent.pdf

Now in your flow run you are using

2023-12-25-TitleofEvent.pdf

This is going to mess up my expression I have given earlier.

Let me know which format you are using? You can't use both formats. Need consistent data quality for processing these.

Thanks
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

Hi @ahmehade

I can see the file name under the compose action step. What is the compose 2 action step? Could you please explain?
ahmehade 15 on at

Like (0)

Report

Re: Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

Thank you so much!

The issue i'm running into here is the automation to create the file actually outputs the file name as "yyyy-mm-dd"

See image for reference.

Screenshot 2023-0...
abm abm 32,464 Most Valuable Professional on at

Like (1)

Report

Re: Need help creating a flow to automate creating a sharepoint folder based off Month/Year in title of file.

Hi @ahmehade

Please see below

Above steps are for creating the folder name using the month name and year.

Expression to get month name and year is as follows:

formatDateTime(first(split(outputs('Compose'),'-')),'MMMM yyyy')

For file upload see below video.

https://www.youtube.com/watch?v=amByVPsgUw8&t=487s

Thanks