Create list item using Sharepoint Online Spoke

[tmparks01]

I see there is a "Create List Item" provided OOTB for the spoke. However, the only value able to be passed is the title of the item. Is there a way to send a JSON object for other columns in the list? Or do I need to create a custom 'Create List Item' action? Thanks.

[Ahmet1]

Hi, did you figure this out? We are also looking for the same solution. It only populates the first column.. It doesn't allow you to specify List Item Entity to insert into

[cuchi]

hi Ahmet1,

i hope you are ok.

i am trying to use the sharepoint spoke to create list items.

i use flow designer for this purpose.

when configuring the action "create list item" it asks for list ID, and custom id fields.

do u know what they are and which values i should put ?

regards,

max

[Ahmet1]

Hi, we ended up going with Power Automate to achieve this objective with integrating SharePoint / ServiceNow. It was much easier and better integrated this way. The ServiceNow plugin does not allow you to populate more than one column in the same row when we were using it in April.

ServiceNow updates send an email to mailbox

Power Automate monitors the mailbox

Power Automate retrieves the values , data from the email 

Power Automate populates SharePoint list.

Same can be done the other way round by monitoring SharePoint list and updating ServiceNow.

[Josh Pirozzi]

Hi @cuchi 

This sounds similar to what we've done for our Integration with Jira. We use Flow Designer to look for when a Field is updated on a Catalog Task and, when populated, it triggers our Flow to pass data from the ServiceNow Task and Generate/Update a Jira Story with field data. 

We have a 'Build JSON Request' Script Step on an Action where we had to call out 'Custom Fields' and their associated ID's. This allows us to pass multiple field data over to Jira. See below for the Script:

(function execute(inputs, outputs) {

// ... code ...

  var desc = inputs.description;

  desc += ',Reporter:'+inputs.req_for;

  var issue = new Object();

issue.fields = new Object();

issue.fields.project = new Object();

issue.fields.project.key = ""+inputs.prj_key

issue.fields.issuetype = new Object();

issue.fields.issuetype.name=""+'Story';

  issue.fields.customfield_12401 = ""+inputs.task_id;

    issue.fields.customfield_12402 = ""+inputs.assignment_group;

    issue.fields.customfield_12601 = ""+inputs.ritm_id;

  issue.fields.customfield_12600 = ""+inputs.task_status;

  issue.fields.description = ""+desc;

  issue.fields.summary = ""+inputs.summary;

var json = new JSON();

var body = json.encode(issue);

outputs.json_body = body;

})(inputs, outputs);

Output Variables: 

Label = json_body

Name = json_body

Type = JSON