Answered

Find List and Create Item

(0) Share

Report

Posted on by legendsIT

I am working on a student check in flow that uses a form submitted by parents to trigger a "create item" action for the list associated with the "StudentID" (a question from the form). When the parent submits the form the flow should use the grade level to determine the SP site to create the list on and the student ID they enter to select the correct list from that site. The flow should then create an item in that list using the responses from the form. Any help would be greatly appreciated Screenshot 2021-03-29 130513.jpg .

I have the same question (0)

All responses (4)

Answers (1)

tom_riha 10,179 Most Valuable Professional on at

Like (1)

Report
Re: Find List and Create Item

Hello @legendsIT ,

if the url and list name can change, you should create the item with an HTTP request. You can't use the existing SharePoint actions as they require fixed url and list name.

Site Address: the full URL to the site Method: POST Uri: _api/web/lists/GetByTitle('[ListName]')/Items Headers: Accept : application/json;odata=verbose Content-Type : application/json;odata=verbose Body: { "__metadata": { "type": "SP.Data.[ListName]ListItem" }, "Column1": "Value1", "Column2": "Value2", "Column3": "Value3" }

Was this reply helpful? Yes No
legendsIT 8 on at

Like (0)

Report

Re: Find List and Create Item

Greetings Tom, thank you for taking the time to help me with this question, your solution fits what I need perfectly. I built my flow modeling yours, but my flow is failing for an error I can't make sense of because the column does exist in the list: "The property 'ExposureToSymptoms?' does not exist on type 'SP.Data.100508533ListItem'. Make sure to only use property names that are defined by the type." Any advice from here?

Was this reply helpful? Yes No
Verified answer

tom_riha 10,179 Most Valuable Professional on at

Like (1)

Report
Re: Find List and Create Item

Hello @legendsIT ,

you must use the column's internal name, and the internal name doesn't support characters like '?'. You can see the column internal name in the URL if you go to List settings -> Edit the column

For column created as 'ExposureToSymptoms?' it would be:

ExposureToSymptoms_x003f_

Was this reply helpful? Yes No
legendsIT 8 on at

Like (0)

Report

Re: Find List and Create Item

That did it, problem solved, your help has been greatly appreciated sir.

Was this reply helpful? Yes No