Convert CSV Files to formatted Excel table (xlsx) in Power Automate | Faster load скачать в хорошем качестве

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/