Power Automate

Power Automate can`t create a Table in excel worksheet

(0) Share

Report

Posted on by frixel

1,021

Hello.

What goes wrong if the Flow has created the file (it is create) but cannot create the Table?

Actually, the intention is to create the table with:

=OFFSET(Worksheet!A1,0,0,SUBTOTAL(103,Worksheet!$A:$A),3)
But since that didn't work either, I tried it as Worksheet!A1:E622 , but unfortunately also without success.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

Sort by

Suggested answer

ninihen 71 on at

Like (1)

Report
Copy link

Link copied!

Delay 10 sec may not be enough. Try delay 60s?

A few things you can try:
- Open CountRows.xlsx, check the sheet tab name. Fix the range if needed.
- Bump Delay to 60s.
- If both don't help, add Get file metadata using path before Create Table and chain through its ItemId.

Tested and the table was created.

Was this reply helpful? Yes No
frixel 1,021 on at

Like (0)

Report
Copy link

Link copied!

Thanks @ninihen.

I set the delay to 60 seconds and add the metadata to the flow.

Also the sheetname is correct but it fails again.

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,489 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @frixel,

I don't think this is a Delay problem, it looks more like an input issue. By the way, before providing you with a solution, it looks like you're using a OFFSET formula as input for the table range - I didn't test creating tables with this approach, but it might lead to problems when running the actin.

The Get file metadata action retrieves the path to the Excel file, which is the input you must provide in the in the File input:

The only problem is that the Path include the reference to the Document Library (Shared Documents in my case), which must not be included in the Create table action, since it is already provided in the Document Library field:

Solution

Add an expression as input to remove the reference to Shared Documents/ from the path property retrieved by Get file metadata. The expression looks like this: replace( outputs('Get_file_metadata_using_path')?['body/Path'], 'Shared Documents/', '' ).

With this, the flow will run successfully, with no need for a delay:

By the way, if you need further instructions on how to add values to this table, you can refer to this blog post: https://digitalmill.net/2026/03/09/how-to-add-or-update-rows-in-excel-tables-created-dynamically-in-power-automate/

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
Suggested answer

Kalathiya 1,862 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @frixel,

I have implemented similar approach.

#1. In the File property, keep the folder path static and put file name dynamic.

#2. In Table range, mention the sheet name along with the range

Example: Sheet1!A1:B150

#3. Also, make sure to define the column names you want in the table.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
frixel 1,021 on at

Like (0)

Report
Copy link

Link copied!

@Kalathiya

Then it is failed again.

Was this reply helpful? Yes No
Kalathiya 1,862 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @frixel,

Try to give table range like below:

Sheet1!A1:B150

Sheet1 - Replace with your sheet name.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No
Suggested answer

ninihen 71 on at

Like (1)

Report
Copy link

Link copied!

I can see progressive improvement from the screenshots. Error went from NotFound to BadRequest. So Get file metadata successfully resolved the file, and Id was passed correctly.

The progblem is the OFFSET formula. That is not a valid expression in Power Automate. So you need to give it a range.

To achieve the same effect, use a Compose to build the string. If row count is known from the upstream step that produced the file (e.g., a prior SharePoint "Get items" count), just @concat('Worksheet!A1:E', add(length(body('Get_items')), 1)), and then feed that Compose output into Table range.

Was this reply helpful? Yes No
frixel 1,021 on at

Like (0)

Report
Copy link

Link copied!

Yes that`s is working 😀

In that case, what is wrong with: =OFFSET(Worksheet!A1,0,0,SUBTOTAL(103,Worksheet!$A:$A),3)

Was this reply helpful? Yes No
ninihen 71 on at

Like (0)

Report
Copy link

Link copied!

@frixel, this is simply because OFFSET is a formula for excel, not for Power Automate. Just like =A+B won't work in Power Automate.

And BTW if you would be interested in using AI agents to build flow. Claude built this in 20 minutes for me (including creating the excel in SharePoint, built the flow, triggered the flow and examine the outcome).

Here is how we made it (my conversation with the agent). This using a Claude agent in VS Code, connected to Flow Studio MCP (disclaimer, I'm one of the person building it):

Was this reply helpful? Yes No
frixel 1,021 on at

Like (0)

Report
Copy link

Link copied!

This is where i find it and i saw also other people are using this.

Was this reply helpful? Yes No