Skip to main content

How to Create an Item in a SharePoint List in Power Automate

· 7 min read
Jagdish Kumawat
Founder @ Dewiride

Create item, from the SharePoint connector, adds one item to a list: the designer shows a field for each of the list's columns, and the action returns the new item, with its ID, for the actions after it.

The example is Import Old Overtime Timesheet, a flow of the Overtime Timesheet app. For each row of an old Excel timesheet, it creates an item in the OvertimeEntries list, with the shift's date, start and end, break, hours, department, reason, person and decision.

Prerequisites​

  • Permission to add items to the list for the account the flow's SharePoint connection uses. The item is created as that account.

Step 1: Add the Action​

Select + where the item should be created, Add an action, search for Create item, and select it under SharePoint. In the example, it's inside the loop over the rows, and I named it Create the entry, so later expressions read outputs('Create_the_entry').

Step 2: Choose the Site and the List​

Fill Site Address and List Name. Pick them from the drop-downs, or, in a flow that moves between environments, use environment variables: Enter custom value, then the variables from dynamic content (How to Use Environment Variables in a Power Automate Flow).

Once the list is chosen, the pane shows a field for each of its columns. The required columns, marked with an asterisk, are at the top.

Step 3: Fill the Columns​

Put a value in each field, typed, from dynamic content or as an expression (How to Add an Expression in Power Automate). The example's required columns:

The Create the entry pane: Site Address and List Name set to the Overtime Times… and OvertimeEntries… variables, then the required fields WorkDate formatDateTime…, StartTime Outputs, EndTime Outputs, BreakMinutes int(...), Hours Outputs, DepartmentId first(...), Department, Reason and EmployeeName from the Excel row

ColumnTypeValue
WorkDateDate onlyformatDateTime(items('For_each_old_row')?['Date'], 'yyyy-MM-dd')
StartTimeDate and timeOutputs of Shift start, a UTC time
EndTimeDate and timeOutputs of Shift end
BreakMinutesNumberint(items('For_each_old_row')?['Break (mins)'])
HoursNumberOutputs of Hours
DepartmentIdNumberfirst(body('Matching_department'))?['ID']
DepartmentSingle line of textDepartment from the Excel row
ReasonMultiple lines of textReason from the Excel row
EmployeeNameSingle line of textEmployee from the Excel row
WorkMonthSingle line of textformatDateTime(items('For_each_old_row')?['Date'], 'yyyy-MM')

What each type takes:

Step 4: Fill the Optional Columns​

Optional columns are under Advanced parameters. Pick the ones you need from its list, or select Show all:

The rest of the pane: WorkMonth formatDateTime…, then Advanced parameters showing 3 of 8 with EmployeeEmail first(...), Status Value Approved, and DecisionBy Authorised by from the Excel row

ColumnTypeValue
EmployeeEmailSingle line of textfirst(body('Exact_name_matches'))?['Mail']
Status ValueChoiceApproved, picked from the column's choices
DecisionBySingle line of textAuthorised by from the Excel row

A Choice column appears with Value after its name, here Status Value, with the column's choices in a drop-down.

Step 5: Use the New Item​

Create item returns the item it created. The next actions read its fields from the action's outputs, for example its ID and its ETag, the version SharePoint uses to check nothing changed it in between:

The new item's ID
outputs('Create_the_entry')?['body/ID']
The new item's ETag
outputs('Create_the_entry')?['body/@odata.etag']

In the example, Approve the entry uses both to approve the item that was just created (How to Approve or Reject a SharePoint Item in Power Automate).

The Result​

After the run, the list had an item for each imported row, with the times in UK time:

The OvertimeEntries list grouped by WorkMonth 2026-10 (12) and EmployeeName: Aisha Khan (4) with shifts on 02/10, 10/10 to 11/10, 13/10 and 30/10, sum 16.50 hours, and Ben Harris (3) with shifts on 04/10, 17/10 and 24/10 22:00 to 25/10 06:00 with a 60-minute break and 8.00 hours, sum 16.00

Common Mistakes​

MistakeWhat happensDo this instead
Leaving a required field emptyThe designer marks it as requiredFill every field marked with an asterisk
A local time in a date and time columnTimes are an hour out in summerConvert to UTC first
Looking for an optional column in the main listIt's under Advanced parametersPick it there, or Show all
Expecting the item's Created By to be the person in the rowIt's the account of the flow's connectionStore the person in a column of your own

Troubleshooting​

SymptomLikely causeFix
A choice isn't offeredIt isn't one of the column's choicesAdd it to the column's choices in SharePoint
The time is wrong in SharePointA local time was saved as if it were UTCconvertToUtc()
The next action can't find the IDIt's in body/IDoutputs('<action>')?['body/ID']

FAQ​

Who is the item's Created By?​

The account the action's SharePoint connection uses. In the example, that's the flow's owner, for every imported row.

Can I create several items at once?​

Create item creates one. Put it in an Apply to each loop to create one per row (How to Loop Through an Array with Apply to Each in Power Automate).

How do I change an item later?​

With Update item and the item's ID (How to Update a SharePoint List Item in Power Automate).

Conclusion​

Create item adds one item to a list: choose the site and list, fill a field per column, with UTC times for date and time columns and optional columns under Advanced parameters, and read the new item's ID and ETag from its outputs.

Additional Resources​