Create Item in List Called with Dynamic Content

[ZachJayy]

Hello, here's some context before my question. 

I am using the Send an HTTP Request to Sharepoint action to create a list on my site with JSON. This list has four columns that I'm creating. 

Downstream, I want to use the Create Item action (or the Send an HTTP Request to Sharepoint) to generate a new item on that list that I created.

The problem I'm having is: my method for selecting this list is based on dynamic content coming from a trigger. As you can see below, I'm not manually configuring this flow to select a certain list. The flow needs to allow for the list it adds an item to to be variable based on trigger content. That alone isn't the problem, because using dynamic content to select the list will allow me to create an item using only the Title column. But I need to populate data into the other three columns as well.

So what I'm looking for is a way to create an item on a sharepoint list (with data on all columns) when that list isn't being manually chosen by the flow and is instead a custom value based on dynamic content. Any creative solutions out there?

[annajhaveri]

As alternate solution,, you can use REST API in the Send HTTP Request to SharePoint action to create list items, instead of using Create Item action.

[ZachJayy]

@annajhaveri Even with the REST API option, it only seems to include the ability to create the Title column. Is it possible to use the REST API to add data to all of the columns? Could I see an example of how that looks? I've reviewed Working with lists and list items with REST | Microsoft Docs and it only specifies the ability to add to the Title column. 

[annajhaveri]

@ZachJayy , you can update all column data values using REST API. What columns you had and what is the data type of those columns?

[ZachJayy]

@annajhaveri I've attached a screenshot below with arrows pointing to the names of my four columns. 

Title is a single-line text string.

Link is a hyperlink.

Notes is a multi-line text string.

Decision is a choice field offering Approve or Reject. 

I'm also unlcear as to what to use in the coding where the question mark is to call this list specifically. 

[annajhaveri]

Can you try putting Send Email V3 action in start of workflow just to send test email, so that we can figure out whether it is an issue with the action or other logic in the flow?

[ZachJayy]

@annajhaveri Does this work - I've got quite a few actions leading this one:

[annajhaveri]

SP.Data.ListNameListItem

Here ListName is your List Title, E.g. if your list title is "TestList", then it will be SP.Data.TestListListItem and if your list title has space  "Test List" SP.Data.Test_x0020_ListListItem. Also double check what you list URL is, and post it here if its different than list title, then this value could be different. 

So format your json as below, the hyperlink value needs to be provided in different format:

{
"__metadata": {
"type": "SP.Data.ListNameListItem"
},
"Title":"value",
"Link":{
'__metadata': { 'type': 'SP.FieldUrlValue' },
'Description': 'Google',
'Url': 'http://google.com'
}
Notes:"value",
Decision:"value"
}

Thanks,

Anna Jhaveri

[ZachJayy]

@annajhaveri Looks like it may be due to that URL being different. Below is the screenshot of the new error:

https://myshsu.sharepoint.com/sites/Finance-BusinessSolutionsSupport/HR/HR-Onboarding/Lists/Zacj%20B...

There's the URL for the list. Those are underscores between Bellot and 345478 and 2.

[ZachJayy]

@annajhaveri I caught that the name of the list was incorrect in the URI section. When I resolved that I still get the "could not be resolved by the model" error:

[annajhaveri]

Still there seems to be issue with type. Can you go to the list in sharepoint and copy the url from browser and provide the whole part of url that is after sharepoint.com?

[ZachJayy]

@annajhaveri 

/sites/Finance-BusinessSolutionsSupport/HR/HR-Onboarding/Lists/Zacj%20Bellot_345478_2/AllItems.aspx

[annajhaveri]

Hello @ZachJayy ,

Please modify the JSON as below:

{
"__metadata": {
"type": "SP.Data.Zacj_x0020_Bellot_x005f_345478_x005f_2ListItem"
},
"Title":"value",
"Link":{
"__metadata": { "type": "SP.FieldUrlValue" },
"Description": "Google",
"Url": "http://google.com"
},
"Notes":"value",
"Decision":"value"
}

For your reference in order to get the type, you can use API in browser 

https://<siteurl>/_api/web/lists/getbytitle('Zacj%20Bellot_345478_2')?$select=ListItemEntityTypeFullName

This url will show output in your browser and look for value of ListItemEntityTypeFullName in the output,  e.g. in your case it will be <d:ListItemEntityTypeFullName>SP.Data.Zacj_x0020_Bellot_x005f_345478_x005f_2ListItem</d:ListItemEntityTypeFullName>, so the type value in your json will be SP.Data.Zacj_x0020_Bellot_x005f_345478_x005f_2ListItem.

[ZachJayy]

@annajhaveri That seems to have done it - no longer getting an error for the list. My new error is to do with the SP.FieldURLValue. Error screenshotted below. Also including the setup - I am generating a sharing link for a PDF document in sharepoint documents files and trying to insert that link into the column in this list we're updating.

As a side note - where do you learn all of this - where is the information about how to use that URL up there to find the true list name? I feel like a fish out of water with this.

[annajhaveri]

It should work, i dont see any issues, can you provide your full json, just to see if there are any issues with json

[ZachJayy]

@annajhaveri 

{
"__metadata": {
"type": "SP.Data.Zacj_x0020_Bellot_x005f_345478_x005f_2ListItem"
},
"Title": "value",
"Link": {
"__metadata": { "type": "SP.FieldURLValue" },
"Description": "Document",
"Url": "@{outputs('Create_sharing_link_for_a_file_or_folder')?['body/link/webUrl']}"
},
"Notes": "value"
"Decision": "value"
}

[annajhaveri]

I see an issue with Json, there is a comma (,) missing after "Notes": "value"

[ZachJayy]

@annajhaveri I've fixed that missing comma. I am still getting the same error that I was receiving up above. That:

A type named 'SP.FieldURLValue' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.
clientRequestId: b6acade9-20dd-4e5e-ab7d-bfca16c547de
serviceRequestId: 4c58959f-a00f-b000-aa93-a496c9c38bb2

[annajhaveri]

Are you sure that your Link column data type in SharePoint is Hyperlink? as the same scenario of updating sharinglink in hyperlink column  value works.

[annajhaveri]

Also double check the name of Link column, is it Link or something else, go to the List Settings, click on link column and then check URL in browser, and see value of field is it "Link: or something else? e.g. /sites/development/_layouts/15/FldEdit.aspx?List=%7BA18158BA-5E66-4180-BA36-C96525A1BD4D%7D&Field=Link