cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
debbieedwards
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

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

v-yuazh-msft
Community Support
Community Support

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
vecerpa
Memorable Member
Memorable Member

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.

 

 

 

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

 

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

v-yuazh-msft
Community Support
Community Support

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

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

Both solutions worked a treat.

 

Thank you for your help

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,854)