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/quickl...

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:   / maria-graciela-martinez-865a758a  

Follow us on Linkedin:   / power-gi  

Our website: https://powergi.net/