Create SharePoint List from Excel

(0) Share

Report

Posted on by CU13081209-0

Hello

I have a workflow

1. Send Excel to Mailbox

2. Create File in Doc-Library (SharePoint) and read file

3. Add Rows in a List from File (Doc-Library)

Unfortunately the last step (3) is not working because the File (2) is not formatted as table.
The workaround is to save the file locally, format it and upload it to the Doc-Library.

The range changes it is never the same.

Is it possible to configure Power Automate to format the Excel-File as Table.

Regards
Heinrichxx

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

rzaneti 4,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Heinrichxx ,

Yes, it is possible to format the table dynamically, which will work even if the ranges or worksheet names change. To achieve it, you will need to work with Office Scripts.

I know that some organizations have restrictions for the use of this tool, so please confirm if this approach works for you and, if yes, we can move forward in creating a Script for you. In this case, please share a sample of the Excel file (with fake data), so we can see can make sure that the script will work for you use scenario.

To learn a little more about Office Scripts, I recommend the following reading:

- Official docs: https://learn.microsoft.com/en-us/office/dev/scripts/
- Running Office Scripts in PA (official docs): https://learn.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration?tabs=run-script
- Office Scripts: the new VBA: http://digitalmill.net/2023/06/10/office-scripts-the-new-vba/
- Getting started with Office Scripts: http://digitalmill.net/2023/06/19/get-started-with-office-scripts/
- Accessing Excel ranges from PA with Office Scripts: http://digitalmill.net/2023/09/01/accessing-excel-ranges-with-power-automate/
- Sending values from PA to Office Scripts: http://digitalmill.net/2024/01/17/sending-values-from-power-automate-to-excel-with-office-scripts/

Was this reply helpful? Yes No
CU13081209-0 on at

Like (0)

Report
Copy link

Link copied!

Hello Alex
I have checked it.
Do you need Premium or Licences fees to run it?
Regards
Heinrichxx

Was this reply helpful? Yes No
CU13081209-0 on at

Like (0)

Report
Copy link

Link copied!

Hello rzaneti
Is this an Action within flow or does it need a programming.
I would prefer to run it within power automate without having program it.
Regards
Heinrichxx

Was this reply helpful? Yes No
rzaneti 4,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Heinrichxx ,

The idea here is to keep using Power Automate, but using this specific Excel Web feature that allows you to perform some tasks in Excel that are not originally available in the default connector actions. To run the Office Script in an Excel file, we will be using the Power Automate "Run Script" action.

As Office Scripts are written in TypeScript, you will need some lines of code to implement this solution. It works similarly to a VBA code, and you can even "Record Macros" for Office Scripts.

Was this reply helpful? Yes No
CU13081209-0 on at

Like (0)

Report
Copy link

Link copied!

Hello rzaneti
Thank you very much.
Regards
Heinrichxx

Was this reply helpful? Yes No