cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Power Participant
Power Participant

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

Highlighted
Community Support
Community Support

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
Highlighted
Power Participant
Power Participant

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.

 

 

 

Highlighted
Helper I
Helper I

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

 

Highlighted
Power Participant
Power Participant

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

Highlighted
Community Support
Community Support

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

Highlighted
Helper I
Helper I

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

Highlighted
Helper I
Helper I

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (8,344)