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:
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:
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.
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/