cancel
Showing results for 
Search instead for 
Did you mean: 

SharePoint Files - all fields not just a few

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.

Status: Completed

Hello - this feature is now available. You can read more about it here: https://flow.microsoft.com/blog/support-for-sharepoint-document-library-properties/

Comments
Level: Powered On

When building SharePoint workflows with SharePoint designer, you are able to easily select from multiple options when inserting date/people fields - for instance short date/long date, or email address vs display name for "people" columns. It would be great if you could do the same in MS Flow. It pulls up all of the available fields on the list, but not the variations on the fields. 

Level: Power Up

Flow is a really easy to use product, but it seems extremely limited. I would like to use custom SharePoint columns in a flow (branch a workflow based on the selected option in a choice field, update a custom column, read the value out of a custom column, etc.). This doesn't seem to be possible at the moment.

Level 8

When creating a condition logic against a document library, only default field are listed.  Custom fields (metadata) are NOT listed.

This greatly limits the usability of MS Flow on document libraries.

E.g. if I added 'department' as a custom field in a document library.. i cannot add 'department' in the condition logic.

Level: Power Up

This seems very obvious and important.  There is a workaround - but a clumsy one.

Level: Powered On

Can you point me to the workaround ?

 

thanks

Ed

>