cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ccoffman
New Member

Create Item - Sharepoint list fields missing

When I attempt to create a Flow which has an action to create a Sharepoint List Item, the fields that are supplied when the list is selected is a much smaller subset of the fields which that list item has. There are about 20 columns in my list and only 10 or so show. I have some additional fields that I need to update in my FLOW but they are not visible at this time.

 

CreateItem.PNG

Has anyone run into this issue yet?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Create Item - Sharepoint list fields missing

Hi Ccoffman,

 

I got the same result as you did. I assume that some column types in SharePoint list are not supported by the fields in Flow so they will not appear there. Here is my test:

 

  1. My SharePoint list columns, most named according to the column type name. 19 in total.1.JPG
  2. In Flow, only 13 of them are shown. Column types like Person or Group, Choice, Lookup, Hyperlink and Picture, etc. are not supported and weren’t shown.

 2.JPG

 

Microsoft will continue to invest in the integration efforts with more templates for more services and a more complete experience within SharePoint itself. In addition, MS also plan to enhance the flow authoring experience for SharePoint by:

  • Adding read/write support for Person and Taxonomy column types (currently we have read only support)
  • Enabling look up of multi-value properties such as Single-choice, Multiple-choice, and Lookup columns
  • Adding ways to leverage your existing SharePoint workflows in Microsoft Flow.

 

As you know, Flow is still a preview product and you are always welcomed to tell your feedback. Here is the forum link where you could tell MS what you think:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Community Support
Community Support

Re: Create Item - Sharepoint list fields missing

Hi Ccoffman,

 

I got the same result as you did. I assume that some column types in SharePoint list are not supported by the fields in Flow so they will not appear there. Here is my test:

 

  1. My SharePoint list columns, most named according to the column type name. 19 in total.1.JPG
  2. In Flow, only 13 of them are shown. Column types like Person or Group, Choice, Lookup, Hyperlink and Picture, etc. are not supported and weren’t shown.

 2.JPG

 

Microsoft will continue to invest in the integration efforts with more templates for more services and a more complete experience within SharePoint itself. In addition, MS also plan to enhance the flow authoring experience for SharePoint by:

  • Adding read/write support for Person and Taxonomy column types (currently we have read only support)
  • Enabling look up of multi-value properties such as Single-choice, Multiple-choice, and Lookup columns
  • Adding ways to leverage your existing SharePoint workflows in Microsoft Flow.

 

As you know, Flow is still a preview product and you are always welcomed to tell your feedback. Here is the forum link where you could tell MS what you think:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Mona Li

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Bjorn Resolver I
Resolver I

Re: Create Item - Sharepoint list fields missing

Hi Mona,

 

This post was from October 2016, is there any official update on when this is coming? For us to commit to using Flow, it needs to support all data types for Sharepoint List columns, including managed metadata term sets and site columns. And we need the same thing in Document Libraries. I understand that it's still in Preview release, but I'm a bit surprised that you guys didn't start with this core functionality for your own platform. Pinterest, Twitter, Facebook connections are all well and good, but we have more traditional business needs like moving files and metadata between Outlook and Sharepoint, so getting and setting any and all column values is essential.

 

Thanks!

Highlighted
Go Advocate I
Advocate I

Re: Create Item - Sharepoint list fields missing

 I definitely agree with Bjorn. The fact that we're comin up on 6 months since that last response with NO additional updates is NOT a good sign. I am extremely frustrated because for us Office 365 customers, Flow is the closest alternative to the full-fledged capabilities of the Sharepoint workflow that is present when using Sharepoint Designer in a on-premise version of Sharepoint. So, for Flow to be so pitifully limited in its capabilities this long after it first debuted (even if it was a "preview" mode) does not bode well for its chance at continued future success. It seems like Microsoft did what they often do, which is come up with something that might actually be a good idea if it was implemented using some amount of logic, but instead leave it to die on the vine because of their inability to recognize the shortcomings that are obvious to everyone else. I saw a similar post on their idea forum from a year ago, and the Microsoft rep said they planned to fix this issue in the future. Well, it's been a year since that post, and there still is no sign of any fix coming anytime in the near future, if ever. 

Like Bjorn mentioned above, instead of focusing on silly and relatively frivolous integrations like the various social media options, and slew of other integrations to seldom used tools and apps, you might want to work on getting the basics down first. There's no reason that you can't build the capability to update the different column types in Sharepoint lists, as well as the document libraries, through Flow. Right now, Sharepoint is only a fraction of its full self in the Office 365 offering, so it would be nice to try and fill in the gaps in those types of tools and apps first.

RKushner Advocate III
Advocate III

Re: Create Item - Sharepoint list fields missing

I very strongly agree with what Go said here. For me, Flow is first of all a business tool for SharePoint, not a toy for social media! Can we get an update? Do we get an idea when Flow might be released for General Availability as a business tool?

dave_carter
New Member

Re: Create Item - Sharepoint list fields missing

OMG, I had this working a month ago!

 

THIS WAS WORKING THIS MORING AND NOW ITS BROKEN AGAIN!

 

Im catching an emails to an email address.

Saving the attachments into a SPO document lib.

Creating a SPO list item for each attachment with email info and a hyperlink to the document.

 

I discovered a problem in that a email with the same document attached would replace the earlier one.

I added a COMPOSE "@formatdatetime(addhours(utcnow(),12),'yyMMdd_HHmmss ')" to create a date pretext to the filename.

When I tried to add that to the create file action the "attachments" previous step data had vanished and I wasnt able to place it in front of "filename" or "name" (cant remember which it is, attachment name).

Rebuilt the FLOW and all was good, in the Create list item action placed into a Hyperlink the exact same info I had before.

 

All was the same but for the added datetime stamp on the create file, BUT now the Hyperlink field wont populate when it had before.

 

And us guessed it, I had over written the original FLOW - MY BAD!

 

Did the just remove the functionality again or what????????????????????????????

 

LHowle
New Member

Re: Create Item - Sharepoint list fields missing

It is now May 2020 and I'm having the same issue with a Flow from MSForms to SharePoint list. My "choice" columns do not appear in the Dynamic Content box to add to the flow. Surely this was fixed in the past 3 years?

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,801)