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

[debbieedwards]

Im using Get Files (Properties Only)

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

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 

[vecerpa]

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]

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?

[vecerpa · Accepted solution]

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.

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/ 

Hope this helps.

Pavel

[v-yuazh-msft · Accepted solution]

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.

The expression in the Filter Array as below:

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

Best regards,

Alice

[debbieedwards]

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

[debbieedwards]

Both solutions worked a treat.

Thank you for your help