FROM AN EXCEL RANGE TO AN EXCEL TABLE

[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

[v-litu-msft]

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.

[Alice_italy]

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 · Accepted solution]

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.