I CAN´T CREATE TABLE EXCEL WITH FILE IN ONEDRIVE

(1) Share

Report

Posted on by fgonzalez515

296

Hello Community,

When I add an Excel file to OneDrive, I cannot "Create a table", because of the following error.

What I can do?

FLOW

FLOW ERROR

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

trice602 15,331 Super User 2025 Season 2 on at

Like (0)

Report

Re: I CAN´T CREATE TABLE EXCEL WITH FILE IN ONEDRIVE

Hi @fgonzalez515 ,

The issue is Create table action does not except excel formulas to create a table range, such as =offset.

Excel Online (Business) - Connectors | Microsoft Learn

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Re: I CAN´T CREATE TABLE EXCEL WITH FILE IN ONEDRIVE

Does your new Excel file already contain the data, and you are just trying to turn it into an Excel Table? Or is the new Excel file completely blank and you want to create a new blank Table?

If it already has the data in it (including the headers) then try this instead.

=$A$1:INDEX($1:$1048576,COUNTA($A:$A),COUNTA(1:$1))

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: I CAN´T CREATE TABLE EXCEL WITH FILE IN ONEDRIVE

Hi @trice602

That's how it is.
What formula can I apply for the Excel image?

Was this reply helpful? Yes No
fgonzalez515 296 on at

Like (0)

Report

Re: I CAN´T CREATE TABLE EXCEL WITH FILE IN ONEDRIVE

Hi @grantjenkins

Thanks for answering.

Excel already contains data, but it is not in Table format.

I tried the formula you said, but it gives me an error.

What formula can I apply for the Excel image?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Re: I CAN´T CREATE TABLE EXCEL WITH FILE IN ONEDRIVE

I didn't realize that your table is not at the top of your sheet.

If your table is always starting at Column B and row 8, then this formula should work for you. However, this assumes you have no extra non-table data to the right of the table data and below the table data.

=$B$8:INDEX($8:$1048576,COUNTA($B8:$B1048576),COUNTA(8:$8)+1)

Was this reply helpful? Yes No
Verified answer

fgonzalez515 296 on at

Like (0)

Report

Re: I CAN´T CREATE TABLE EXCEL WITH FILE IN ONEDRIVE

@grantjenkins

Thanks, but it didn't work for me.
I just defined a large row number and then used filters.

Was this reply helpful? Yes No