Skip to main content

Notifications

Power Automate - Building Flows
Answered

Error in Naming of Subfolder

(0) ShareShare
ReportReport
Posted on by 4,547
I have created a flow that is creating PDF files in a SharePoint Library subfolder.

Everything is working except the naming convention formula.

My intent is to have the library present as Folder-subfolder-file
     Folder: Property Name
     Subfolder: Week Ending and Date

I am successfully pulling in this information as meta data, as shown in the last
screenshot - 'Week Ending' column shows desired content I want displayed as the
subfolder name.

No matter what I've tried, flow keeps breaking up the date portion of the Week Ending
field, creating two additional - unwanted, subfolders.

How/What do I correct so that there is one main folder and one subfolder, with the
subfolder name being 'Week Ending 1/19/2025'

Flow -


SharePoint Button Formula -

SharePoint Library -
  • Suggested answer
    Phineas Profile Picture
    Phineas 4,547 on at
    Error in Naming of Subfolder
    I figured it out -

         
    Text(DatePicker1.SelectedDate, "m-dd-yyyy")
  • Phineas Profile Picture
    Phineas 4,547 on at
    Error in Naming of Subfolder
    That is the default formatting of the DatePicker.

    How would I change the slashes to dashes?
  • Verified answer
    NickWarner Profile Picture
    NickWarner 113 on at
    Error in Naming of Subfolder
    The slashes in your date format denote a folder change, you can't use them in your folder name. if you replace with dashes it should work as you expect.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard