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

create new choice column to sharepoint library using flow

Hi,
 
As stated in subject I'm trying to create a choice field in a library but also need to add this column to default view. So far I managed to create the field but I cant display this column in the default view. The purpose of this flow is help the users to replicate a column to multiple sites using a list in which the user will type the url and the name of the library that requires the new column.
 
This is the code to create a choice column I'm using in the action "sent http request to sharepoint" in flow
 

 

{ '__metadata':
{ 'type': 'SP.FieldChoice', 'addToDefaultView': 'true' },
'Title': 'NewColumn',
'FieldTypeKind': 6,
'Required': 'false',
'Choices': { 'results': ['A', 'B', 'C' ] }
}

 

 
I tried to add the column usingt the addtodefaultview part following some documents of microsoft, but doesn't work. The link used is https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-json-schema
 
Thanks beforehand for any help
3 REPLIES 3
v-alzhan-msft
Community Support
Community Support

Hi @Feibien 

 

The JSON for addSiteColumn should as below:

 {
    "verb": "addSiteColumn",
    "internalName": "siteColumnUser",
    "addToDefaultView": true
 }

 

 

Best regards,

Alice       

 

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

Thanks for your reply.

 

I tried to add that code in my flow, but it gaves me this error 

"Microsoft.SharePoint.Client.InvalidClientQueryException".
 
Searching other Microsoft documents, found this one https://docs.microsoft.com/en-us/sharepoint/dev/schema/field-element-field
According to that article, there's a property called "viewable", but when I use it in my code, Microsoft flow throws an error saying that the property doesn't exists...
 
Screenshot_2.png

 

I really don't know what I'm doing wrong...
 

I gave out on Flow and solved the problem using on Powershell the command add-pnpfield https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/add-pnpfield?view=sharepoint-ps

 

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,568)