Are you looking to automatically add a table to an excel file using PowerAutomate? Let me show you how you can save an excel or indeed a CSV (and covert to Excel) attachment to a SharePoint document library and then convert the active cells of the worksheet into a Table.
00:00 Intro
00:20 Example Excel File
02:00 Power Automate Solution
06:10 Putting Flow into Test
06:29 How to overcome an error when overwriting an Excel file with a table
07:48 Waiting for the email and XLSX & CSV attachments
08:22 The flow run history
09:09 Checking out the files on SharePoint (Now with a table)
09:51 The error received when overwriting an Excel file with a table
11:18 Limitations
11:57 Summary, Like and Subscribe
CSV to Excel Video Demo
• CSV to Excel Power Aut...
Known Limits for Excel Actions
docs.microsoft.com/en-gb/conn...
Excel Office Scripts
support.microsoft.com/en-us/o...
Office Script:
function main(workbook: ExcelScript.Workbook,
TableName: string = "Table1",
SheetName: string = "Sheet1"
) {
// Get the worksheet by name
const selectedSheet = workbook.getWorksheet(SheetName);
// Alternatively, get the first worksheet (uncomment below and comment out above)
// const selectedSheet = workbook.getFirstWorksheet();
// Create a table using the data range.
let newTable = workbook.addTable(selectedSheet.getUsedRange(), true);
newTable.setName(TableName);} Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕
27 июн 2024