When working with the Flow SharePoint File connector (On File Create), I notice it is very limited as to the "fields" available.
In SharePoint, we often create new metadata fields for our libraries - like Customer, Value, Assigned To, and so on.
I tried making a Flow such that as a Salesman adds a new Proposal to SharePoint (Word doc format), it would create a Microsoft CRM Opportunity to track it. However, not enough data is available from the SharePoint file metadata to add to the Opportunity.
Specifically, SharePoint files have Created Date/By, Modified Date/By, but these aren't available in Flow. In additon, we have added Customer (text field) and Quoted Value (Number field) to the document library in order to capture the meta-data and show it in the SharePoint view. I want to add these to the Opportunity.
The SharePoint List connector grabs all the fields/meta-data - the Files connector does not.
Hello - this feature is now available. You can read more about it here: https://flow.microsoft.com/blog/support-for-sharepoint-document-library-properties/