FROM AN EXCEL RANGE TO AN EXCEL TABLE

Like (0) Share

Report

Posted on 15 Oct 2020 15:38:16 by Alice_italy

Hello everybody,

I need to create a new excel sheet with a table; in this table there will be the records of another excel sheet but this last is based on range (interval),

how can I do?

wich triggers or actions I can use?

thanks to the community

Categories:

Business Process Flows

All responses (4)

Answers (1)

Suggested answer

takolota1 4,863 Super User 2025 Season 1 on 21 Oct 2024 at 22:38:20

Like (0)

Report

FROM AN EXCEL RANGE TO AN EXCEL TABLE

You can also use this template Azure Function to pull data from any Excel sheet without the need for table formatting...
https://community.powerplatform.com/galleries/gallery-posts/?postid=eea06380-8483-ef11-ac21-7c1e5201b42f

Or if you need something without premium connectors, then you can use these Office Script templates…

https://community.powerplatform.com/galleries/gallery-posts/?postid=9f7a7bcf-c88f-ef11-ac20-7c1e525bd67d
Verified answer

v-litu-msft on 19 Oct 2020 at 07:25:53

Like (0)

Report

Re: i Re: FROM AN EXCEL RANGE TO AN EXCEL TABLE

Hi @Alice_italy,

Sorry Alice, if there is no table exists in the Excel file, there is no action that could get the JSON return could be used in Power Automate.

As a workaround, you could save this Excel file without a table as a CSV file,

Then use Get file content to get the CSV file content, then process it by using expression to let them could be inserted in Excel table, you could refer to this post:

https://powerusers.microsoft.com/t5/Building-Flows/Insert-row-from-csv-into-new-file/m-p/713686

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Alice_italy 58 on 18 Oct 2020 at 06:15:33

Like (0)

Report

Re: i Re: FROM AN EXCEL RANGE TO AN EXCEL TABLE

Hi @v-litu-msft, thanks for you good explanation,
I think your solution is if I had a table at the beginning, but I haven't,

as written before I haven't a table but an excel range,

below is just an example

so, from a range of data I need that flow make a table, is it possible?

thank you for your support
v-litu-msft on 16 Oct 2020 at 07:05:28

Like (1)

Report

i Re: FROM AN EXCEL RANGE TO AN EXCEL TABLE

Hi @Alice_italy,

1. You could use Select action to filter out these columns you need in the original excel table.

2. Then Create a worksheet

3. Create table, table range could be worksheetName! + table range, for example: NewCreatedWorksheet!A1:C1

4. Then create an Apply to each action to loop through each row of the output get from Select action, then add to the new excel table:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.