Answered

Create Item in List Called with Dynamic Content

(0) Share

Report

Posted on by 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?

I have the same question (0)

All responses (22)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

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.

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

@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.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

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

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

@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.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

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?

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

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

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Re: Create Item in List Called with Dynamic Content

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

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

@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%20Bellot_345478_2/AllItems.aspx

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

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

@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:

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Create Item in List Called with Dynamic Content

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?

Was this reply helpful? Yes No