lists column
3 TopicsSharepoint Lists: Format for POST Request to create Column as Choice with Multi Select Enabled
I am relatively new in using the Graph API. I am working on a script that creates new columns for an existing List on my company's SharePoint site. I am having trouble in creating a Choice Field Column that has Multiple Selection Enabled. I followed the documentation to create a Choice Field with the default (single select) as follows: const apiUrl = `https://graph.microsoft.com/v1.0/sites/${siteId}/lists/${listId}/columns`; const response = await fetch(apiUrl, { method: "POST", headers: { Authorization: `Bearer ${accessToken}`, "Content-Type": "application/json", }, body: JSON.stringify(columnPayload), }); Where, columnPayload looks like the following: { "name": "Color", "choice": { "choices": ["Red", "Green", "Blue", "Purple"], "displayAs": "dropDownMenu" } } As expected I see the column created properly.... (Split bottom photo for cleaner view) Now, what changes must I make to have the Allow Multiple Selections toggle enabled when creating the column via the POST request. As we can see, by default, it is not enabled. I have looked over the documentation and have yet to come across anything that provides a solution. I assumed there would be additional fields within the "choice" field in the JSON body to specify this, however, I only see the following on the graph api site: I would appreciate any guidance on this.114Views0likes0CommentsFormula help needed
Hi all. I need help with a simple formula, I've been trying for days, but I'm unable to find a solution... In a list, I have: A column called [Power] with choices from 1 to 4. A column called [Impact] with choices from 1 to 4. A column called [Total_Score] with formula= [Power]*[Impact]. My quest: A column called [Management_Style], a calculated column, where I would like to make a matrix (powerXImpact) Matrix: If power =3 or 4, and impact = 3 or 4; then "Manage Closely" If power= 3 or 4, and impact =1 or 2; then "Keep Satisfied" if power = 1 or 2, and Impact = 3 or 4; then "Keep Informed" If power= 1 or 2, and impact= 1 or 2; then "Monitor (Minimum Effort)" I tried many types if multiple IFs, ANDs, ORs, but I could not find the right formula. Any help is really appreciated. Thank you all!Solved1.1KViews0likes1Comment