Convert CSV Files to formatted Excel table (xlsx) in Power Automate | Faster load

00:05 Introduction to CSV to Excel conversion
00:40 Using Graph API for conversion
01:14 Preparing CSV file and template
02:18 Creating Excel table template
02:58 Setting up Power Automate flow trigger
04:01 Extracting CSV file content
05:03 Handling dynamic file content
06:43 Converting base64 to text
08:27 Transforming CSV file
12:33 Using Select action to format data
14:56 Copying template for new file
20:07 Preventing infinite flow loop
21:29 Extracting drive and item IDs
24:31 Formatting item ID with expressions
25:45 Preparing to add rows via HTTP action
27:01 Setting up HTTP pre-authorized action
28:56 Passing formatted data to HTTP request
29:54 Troubleshooting hidden characters error
30:36 Successful data insertion and good-bye

The blog that this video is based: https://www.matthewdevaney.com/quickly-add-multiple-rows-to-excel-table-in-power-automate/

Some functions used
1. convert CSV content to text
@{base64ToString( body('Get_file_content')?['$content'] )}

2. Drive ID
@{actions('Get_file_metadata')?['inputs']?['parameters']?['drive']}

3. Item ID
@{replace(replace(replace(
first(
split(
last(
split(
outputs(
'Get_file_metadata'
) ?['body/@odata.context'],
'/Files'
)
),
'/Tables('
)
),
'''',
''
),')',''),'(','')}
Follow Graciela on Linkedin: https://www.linkedin.com/in/maria-graciela-martinez-865a758a/

Follow us on Linkedin: https://www.linkedin.com/company/power-gi

Our website: https://powergi.net/

Видео Convert CSV Files to formatted Excel table (xlsx) in Power Automate | Faster load канала Graciela @ Power GI