Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Power Automate SharePoint Connector Issue

(0) ShareShare
ReportReport
Posted on by 23

So I'm having a problem in Power Automate with an action in the SharePoint connector. The Folder Path specified by the "When a file is created" trigger does not match up with the formatting expected by the Folder path input for other SharePoint actions.

 

The error was Folder not found, which was odd to me because I was looking right at the folder in SharePoint.

 

Here's the flow:

gfpierce_1-1628875112235.png

The Folder path dynamic content comes from the trigger. 

 

Now here is what that unaltered Folder path contains:

gfpierce_2-1628875179543.png

 

And here is what the Folder path input expects for a successful query:

gfpierce_3-1628875218925.png

The difference is that the correct formatting has a slash character at the beginning and no slash character at the end. The path as it comes from the trigger has no slash at the beginning and a slash character at the end.

 

I was able to clean the string and generate a successful request programmatically through the following methodology:

 

Initialize a String variable for the Folder path:

gfpierce_4-1628876374302.png

 

Initialize an Integer variable for the Length of the Folder path:

gfpierce_5-1628876403420.png

 

Generate a cleaned folder path with the substring function:

gfpierce_6-1628876524990.png

 

Using the cleaned string in the "Get folder metadata using path" action works and successfully finds the folder in question.

 

I hope this helps someone else who may encounter the same issue.

 

 

  • gfpierce Profile Picture
    gfpierce 23 on at
    Re: Power Automate SharePoint Connector Issue

    A distant "womp womp" echoes in the back of my mind

  • Verified answer
    gfpierce Profile Picture
    gfpierce 23 on at
    Re: Power Automate SharePoint Connector Issue

    Marking this as solved.

  • cchannon Profile Picture
    cchannon 4,702 on at
    Re: Power Automate SharePoint Connector Issue

    *sad trombone noise

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,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard