cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Share your ideas and vote for future features

Suggest an idea
JRitmeijer

SharePoint File triggers need to return numerical ID

Submitted on ‎03-29-2017 11:01 AM Submitted by Kudo Collector on ‎03-29-2017 11:01 AM
TL;DR: The SharePoint File triggers (e.g. 'When a file is modified) also need to return the numerical ID of the item. In addition, or as an alternative, the 'Get file metadata' activities need to return the numerical ID in the ID field, not the path (as the path is already known because it is an input parameter)   I have a very common scenario, which is a SharePoint Document Library with a number of custom columns. When a change is made I need the following information in my Flow:   File Name Content of a custom column   Should be pretty easy, right?   Now, here is the problem. I can use the 'When a file is modified' trigger, which nicely gives me the file name. However, there is no way to get to the metadata for the item as:   'Get file metadata using path' does not return custom columns (and the ID field does not contain the numerical ID) 'Get item', which does return the custom columns, requires the numerical ID of the file, which is not available on the trigger (or on 'Get file metadata using path'.   I have tried to turn it upside down and use ‘When an existing item is modified’ as the trigger. This nicely gives me the numerical ID, but not the file name. I can get the file name using 'Get file metadata using path' if only I had the path to the item, which I don't have, I have the ID. ... View more
Status: Completed

Hi there, I'm happy to report that this is now avaliable. We have added some new triggers that return you all of the library columns as properties, along with the item id. See the details in this blog post: https://flow.microsoft.com/en-us/blog/support-for-sharepoint-document-library-properties/

See more ideas labeled with:
5 Comments (5 New)
AnotherMSprofil

copy file sharepoint - keep Content Type and Metadata

Submitted on ‎11-22-2017 08:03 AM Submitted by Advocate III on ‎11-22-2017 08:03 AM
Hello.   Currently, when a file is copied in SharePoint using the "Copy File" action, it loses it's Content Type and Metadata. In addition, no numeric File ID is returned by the Action, so I can't use "Update File Properties" etc.   Proposals: 1. In addition to the "Overwrite" checkbox add the "Copy Metadata" checkbox that would transfer over all the metadata, including content type (if present in the destination Document Library)   2. Ensure that the FIle Copy action returns the numeric File ID that other actions require. Or update all other Sharepoint actions to work with Indentifier ("\path\file.ext") - whichever is easier.   Thanks! ... View more
Status: New
See more ideas labeled with:
Comment
Labels

Helpful resources