Find List and Create Item

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

[tom_riha]

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"
}

[legendsIT]

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?

[tom_riha · Accepted solution]

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_

[legendsIT]

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