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!

Categories:

Using flows

I have the same question (1)

All responses (7)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ahmehade 15 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ahmehade

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

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ahmehade 15 on at

Like (1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ahmehade 15 on at

Like (1)

Report
Copy link

Link copied!

Amazing, thank you so much!

That worked perfectly 🙂

Was this reply helpful? Yes No