Power Automate Developer for Excel Integration

via Freelancer ·

Budget / Salary£20–250
TypeFreelance project
LocationRemote
Posted2 hours ago
I need a Power Automate developer to build an automated workflow connected to an Excel workbook stored in SharePoint/OneDrive.

The workbook contains a master data table and a dropdown list of account names. As new accounts are added to this dropdown list, I want Power Automate to automatically:

Detect the new account value.

Create two new worksheet inside the same Excel file.

Generate a full copy of the master data table for each sheet on that new sheet.

Replace one specific field/value in the copied data with the new account name that triggered the flow.

Name the sheet using the new account value.

This must run server‑side using Excel Online connectors (no desktop macros), and must be fully dynamic — meaning the flow should work for any future account added to the dropdown list without further modification.

Experience required:

Power Automate (Excel Online Business connector)

Dynamic table handling

“List rows present in a table” + “Add a worksheet” + “Add a table” actions

SharePoint/OneDrive integration

Parameterised row transformation

Error‑safe looping and sheet naming
visual basic data entry excel microsoft access data integration automation data management power automate microsoft 365 workflow automation
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.