cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
debbieedwards
Level: Powered On

Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Im using Get Files (Properties Only)

GetFilesPropertiesOnly.GIF

Howev I have folders within my Library that I need to connect to.

 

If you look at When a file is created (Properties only), it has Site Address, Library Name AND folder

SharepointFileAndFolder.GIF

 

My question is where is Folder for Get Files (Properties Only) ?  Its not in advanced options. 

It doesnt work if  you try adding everything into Library Name 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Hello @debbieedwards,

 

It is not possible to insert path to specific folder for this action.

Otherwise one of parametr that is returned from this action is Path. You can see it in Output, when you test this action over your document library.

FLow_GetItems1.jpg

 

This Path can be used in Apply to each - Condition to pick only files that are within specific Folder, like you can see on printscreen below I am looking for Folder - General/Office 365 Projekty 2019/ 

 

FLow_GetItems2.jpg

 

Hope this helps.

 

Pavel

View solution in original post

Community Support Team
Community Support Team

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Hi @debbieedwards,

 

The function to choose a folder in the trigger "When a file is created (Properties only)" of sharepoint connector is supported in microsoft flow.

However, the function to choose a folder in the action "Get files (Properties only)" of sharepoint connector is not supported in microsoft flow currently.

So there is no any way to choose a folder in the action "Get files (Properties only)" currently.

If you would like the function to  choose a folder in the action "Get files (Properties only)"to be supported in microsoft flow.You could submit an idea to flow idea forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

As an alternative way, you could add a Filter Array action under the action "Get files (Properties only)" to filter out only the files in your special folder.

Capture.PNG

The expression in the Filter Array as below:

@and(contains(item()?['{Path}'], 'folderName'),contains(item()?['{Identifier}'], '.'))

 

Best regards,

Alice

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Hello @debbieedwards,

 

As described here - https://docs.microsoft.com/cs-cz/connectors/sharepointonline/#get-files--properties-only- this action is picking all Folders within Document library. You can specify targeted files by OData filter or by another actions that will follow after this one.

 

And the trigger one is possible to target to specific folder. https://docs.microsoft.com/cs-cz/connectors/sharepointonline/#when-a-file-is-created--properties-onl... 

 

Hope this helps

P.

 

 

 

debbieedwards
Level: Powered On

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Ive tried reading these and I just cant figure out what Im supposed to do using these documents

 

Ive tried adding Microsoft Analytics/Folder1/Folder2 to the Libraryname but it cant be found. Is there any chance you could explain exactly what I need to do to get this working?

ListNotFoundError.GIF

 

Super User
Super User

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Hello @debbieedwards,

 

It is not possible to insert path to specific folder for this action.

Otherwise one of parametr that is returned from this action is Path. You can see it in Output, when you test this action over your document library.

FLow_GetItems1.jpg

 

This Path can be used in Apply to each - Condition to pick only files that are within specific Folder, like you can see on printscreen below I am looking for Folder - General/Office 365 Projekty 2019/ 

 

FLow_GetItems2.jpg

 

Hope this helps.

 

Pavel

View solution in original post

Community Support Team
Community Support Team

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Hi @debbieedwards,

 

The function to choose a folder in the trigger "When a file is created (Properties only)" of sharepoint connector is supported in microsoft flow.

However, the function to choose a folder in the action "Get files (Properties only)" of sharepoint connector is not supported in microsoft flow currently.

So there is no any way to choose a folder in the action "Get files (Properties only)" currently.

If you would like the function to  choose a folder in the action "Get files (Properties only)"to be supported in microsoft flow.You could submit an idea to flow idea forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

As an alternative way, you could add a Filter Array action under the action "Get files (Properties only)" to filter out only the files in your special folder.

Capture.PNG

The expression in the Filter Array as below:

@and(contains(item()?['{Path}'], 'folderName'),contains(item()?['{Identifier}'], '.'))

 

Best regards,

Alice

View solution in original post

debbieedwards
Level: Powered On

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Thank you so much. This is great. I will try this ASAP and let you know how I get on

debbieedwards
Level: Powered On

Re: Sharepoint - When a file is created (Properties only) and Get Files (Properties Only)

Both solutions worked a treat.

 

Thank you for your help

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 141 members 5,526 guests
Please welcome our newest community members: