Moving SharePoint List Items with a Canvas App, Power Automate & Azure Runbook

In this solution, I built a Canvas App that allows users to move items from one SharePoint list to another using a simple UI:
One button and 3 text fields.
Behind the scenes, the process is fully automated using Power Automate and an Azure Automation Runbook.

The goal is to keep the app simple for the user, while handling the heavy logic securely and efficiently in the backend.

How the Solution Works

Result
All items are successfully moved with a single click, no manual copying, no risk of partial moves, and no direct SharePoint permissions required in the app.

Canvas App
The user fills in four text fields (for example: source list, target list, item identifiers, or metadata) and clicks a button.

Power Automate Flow Triggered
The button triggers a Power Automate flow, passing the input values from the Canvas App as parameters for the Runbook.

Azure Automation Runbook Starts
The flow securely starts an Azure Automation Runbook, which contains the logic for handling SharePoint operations.

SharePoint List Processing
The Runbook:

Reads items from the source SharePoint list

Creates matching items in the target SharePoint list

Removes (or archives) the original items from the source list

Example Use Cases

Archiving completed tasks
Moving requests between workflow stages
Separating active and historical data
Bulk list management without direct SharePoint access

By combining a Canvas App with Power Automate and an Azure Runbook, this solution delivers a low-code user experience with enterprise-grade automation.
The user interacts with a simple interface, while the system handles complex SharePoint operations reliably in the background.

Canvas app